Convert PARQUET to DTA
Turn PARQUET files into DTA. A Stata 14 file (format 118), which Stata 14 and later open.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop PARQUET files on the dialor turn it to pick what to do
A Stata file from your Parquet data.One DTA file in Stata 14 format, with typed columns kept as numbers, dates and text.
What you get
A single Stata 14 file (format 118), which Stata 14 and later open. Integers, decimals and doubles become numbers. True and false become 1 and 0.
Dates and times become dates and times in UTC. Dates use the %td format, and other times use %tc.
How columns are changed
Lists, structs, maps and binary values become text, such as [20.1, 40.2]. Empty values become missing.
Whole numbers become byte, int or long variables where they fit. Whole numbers beyond 2^53 become text so no digit is lost.
Text longer than 2,045 bytes becomes a strL.
Column names
Column names become Stata names of up to 32 letters, digits and underscores. When a name has to change, the original is kept as the variable label, so you can still see what the column was called.
To go the other way, use DTA to PARQUET.
PARQUET and DTA.What each format is.
The formats
Parquet
The columnar data format of analytics. Compressed, typed and fast to scan.
- Extensions
- .parquet .pq
- MIME type
- application
/vnd .apache .parquet - Kind
- Text and data
Stata Data
Stata datasets.
- Extensions
- .dta
- MIME type
- application
/x -stata -dta - Kind
- Text and data
In your code.The same PARQUET to DTA conversion through the API, for your app or your agent.
$ cv convert report.parquet report.dta$ cv convert report.parquet report.dtaQuestions.What people ask about PARQUET to DTA.
The file is in Stata 14 format (format 118). Stata 14 and later open it.
Lists, structs, maps and binary values become text, such as [20.1, 40.2]. They are not split into separate variables.
Whole numbers beyond 2^53 become text, so no digit is lost. They are not stored as numbers.
They become Stata names of up to 32 letters, digits and underscores. The original name is kept as the variable label.