Posted
by Brian
on Stack Overflow
See other posts from Stack Overflow
or by Brian
Published on 2010-03-29T06:03:54Z
Indexed on
2010/03/29
6:13 UTC
Read the original article
Hit count: 434
Is there a way to convert a dta file to a CSV? I don't have a version of Stata so I can't do something like save as CSV file.
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
This is from the DBD::File-documentation:
f_ext
This attribute is used for setting the file extension where (CSV) files are opened. There are several possibilities.
DBI:CSV:f_dir=data;f_ext=.csv
In this case, DBD::File will open only table.csv if both table.csv and table exist…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is my class,
public class FreebasePeopleResults {
public String intendedSearch;
public String weight;
public Double heightMeters;
public Integer age;
public String type;
public String parents;
public String profession;
public String alias;
public String children;
public String siblings;
public…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
What am I trying to do: export data to csv.
I have a form which allows user to select the format (from a drop down menu). So based on the selection of the format the ouput is displayed using a ajax call. Works fine for html but when I select the format as csv I don't see any pop up on the screen…
>>> More
as seen on Super User
- Search for 'Super User'
I have these 3 files
21/08/2014 07:15 PM 122 Tw2AWK.csv
21/08/2014 07:15 PM 125 Tw2Notepad.csv
21/08/2014 07:15 PM 119 Tw2REPL.csv
C:\myfilesfile Tw2AWK.csv TwREPL.csv Tw2Notepad.csv
Tw2AWK.csv; UTF-8 Unicode text, with CRLF line terminators
Tw2REPL…
>>> More
as seen on Super User
- Search for 'Super User'
My data:
It's a 71 MB file with 1.5 million rows.
It has 6 fields
All six fields combine to form a unique key - so that's what I need to sort on.
Sort statement:
sort -t ',' -k1,1 -k2,2 -k3,3 -k4,4 -k5,5 -k6,6 -o output.csv input.csv
The problem:
If I sort without keys, it takes 30 seconds…
>>> More
