convert .dat file to .csv for World Bank Salaries

CulturedCheese / thesis-project

4 stars 4 forks source link

Closed ClimbsRocks closed 9 years ago

ClimbsRocks commented 9 years ago

the world bank data file is saved as a .dta stata file. we need it in a .csv file for import to MySQL

ClimbsRocks commented 9 years ago

solved it using python!

import sys import pandas as pd

def main(): data = pd.io.stata.read_stata('OWWupdate1983_2008.dta') data.to_csv('allSalariesByCountry.csv')

if name == 'main': main()