There is gocarina/gocsv which handles custom struct in the same way encoding/json does. You can also write custom marshaller and unmarshaller for specific types. Example: type Client struct { Id string `csv:”client_id”` // .csv column headers Name string `csv:”client_name”` Age string `csv:”client_age”` } func main() { in, err := os.Open(“clients.csv”) if err != nil { … Read more
One way using GNU awk and FPAT awk ‘BEGIN { FPAT = “([^, ]+)|(\”[^\”]+\”)” } { sum+=$3 } END { print sum }’ file.txt Result: 192
How about using the FileLinks class from IPython? I use this to provide access to data directly from Jupyter notebooks. Assuming your data is in pandas dataframe p_df: from IPython.display import FileLink, FileLinks p_df.to_csv(‘/path/to/data.csv’, index=False) p_df.to_excel(‘/path/to/data.xlsx’, index=False) FileLinks(‘/path/to/’) Run this as a notebook cell and the result will be a list of links to files … Read more
You can use the TextFX plugin: TextFX > TextFX Edit > Line up multiple lines by … Note: This doesn’t work if the file is read only. http://tomaslind.net/2016/02/18/how-to-align-columns-in-notepad/ Update 2019: Download link from SourceForge
I just noticed that Lennart’s answer didn’t work with Python 3.1, but it does work with Python 3.2. They’ve enhanced zipfile.ZipExtFile in Python 3.2 (see release notes). These changes appear to make zipfile.ZipExtFile work nicely with io.TextWrapper. Incidentally, it works in Python 3.1, if you uncomment the hacky lines below to monkey-patch zipfile.ZipExtFile, not that … Read more
Replace ^DJI with INDU (that’s one of the tickers for the Dow) – that will work. No idea why ^DJI stopped working last weekend – someone has made a ‘negative enhancement’. Cheerio GT
d3.csv is an asynchronous method. This means that code inside the callback function is run when the data is loaded, but code after and outside the callback function will be run immediately after the request is made, when the data is not yet available. In other words: first(); d3.csv(“path/to/file.csv”, function(rows) { third(); }); second(); If … Read more
For when automagicalism doesn’t work, and you’re definitely using Excel, use this as the field content. =HYPERLINK(“http://stackoverflow.com”)
or use this hive -e ‘select * from your_Table’ | sed ‘s/[\t]/,/g’ > /home/yourfile.csv You can also specify property set hive.cli.print.header=true before the SELECT to ensure that header along with data is created and copied to file. For example: hive -e ‘set hive.cli.print.header=true; select * from your_Table’ | sed ‘s/[\t]/,/g’ > /home/yourfile.csv If you don’t … Read more
If your CSV cannot contain newlines then all you need is (with GNU awk for FPAT): $ echo ‘foo,”field,””with””,commas”,bar’ | awk -v FPAT='[^,]*|(“([^”]|””)*”)’ ‘{for (i=1; i<=NF;i++) print i ” <” $i “>”}’ 1 <foo> 2 <“field,””with””,commas”> 3 <bar> or the equivalent using any awk: $ echo ‘foo,”field,””with””,commas”,bar’ | awk -v fpat=”[^,]*|(“([^”]|””)*”)” -v OFS=’,’ ‘{ rec … Read more