stata
Convert a dta file to csv without Stata software
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!
Pandas long to wide reshape, by two variables
Here’s another solution more fleshed out, taken from Chris Albon’s site. Create “long” dataframe raw_data = {‘patient’: [1, 1, 1, 2, 2], ‘obs’: [1, 2, 3, 1, 2], ‘treatment’: [0, 1, 0, 1, 0], ‘score’: [6252, 24243, 2345, 2342, 23525]} df = pd.DataFrame(raw_data, columns = [‘patient’, ‘obs’, ‘treatment’, ‘score’]) Make a “wide” data df.pivot(index=’patient’, columns=”obs”, … Read more