The frankly-incredible data-analysis library for Python called Pandas has a function to read Stata files. After installing Pandas you can just do: >>> import pandas as pd >>> data = pd.io.stata.read_stata(‘my_stata_file.dta’) >>> data.to_csv(‘my_stata_file.csv’) Amazing!
Try calling read_csv with encoding=’latin1′, encoding=’iso-8859-1′ or encoding=’cp1252′ (these are some of the various encodings found on Windows).
You can use Notepad++ to evaluate a file’s encoding without needing to write code. The evaluated encoding of the open file will display on the bottom bar, far right side. The encodings supported can be seen by going to Settings -> Preferences -> New Document/Default Directory and looking in the drop down.
Yes, you need to wrap in quotes: “some value over two lines”,some other value From this document, which is the generally-accepted CSV standard: Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes
In Windows it is dependent on the “Regional and Language Options” customize screen where you find a List separator. This is the char Windows applications expect to be the CSV separator. Of course this only has effect in Windows applications, for example Excel will not automatically split data into columns if the file is not … Read more
Try: awk -F’,’ ‘{print $3}’ myfile.txt Here in -F you are saying to awk that use , as the field separator.
You need to use two options for the sort command: –field-separator (or -t) –key=<start,end> (or -k), to specify the sort key, i.e. which range of columns (start through end index) to sort by. Since you want to sort on 3 columns, you’ll need to specify -k 3 times, for columns 2,2, 1,1, and 3,3. To … Read more
Use 2 quotes: “Samsung U600 24″””
The CSV “standard” (such as it is) does not dictate how comments should be handled, no, it’s up to the application to establish a convention and stick with it.
Enclose the field in quotes, e.g. field1_value,field2_value,”field 3,value”,field4, etc… See wikipedia. Updated: To encode a quote, use “, one double quote symbol in a field will be encoded as “”, and the whole field will become “”””. So if you see the following in e.g. Excel: ————————————— | regular_value |,,,”| ,””, |””” |”| ————————————— the … Read more