csv-export-xlsx-creation.py

import pandas as pd

# create dataframe
city_data = pd.read_csv('../../Documents/Udacity/city_data.csv')
global_data = pd.read_csv('../../Documents/Udacity/global_data.csv')

my_city_data = city_data.loc[city_data['city'] == 'Kigali']
paris_data = city_data.loc[city_data['city'] == 'Paris']

# render dataframe as xlsx
writer = pd.ExcelWriter('my_city_data.xlsx')
my_city_data.to_excel(writer)
writer.save()

writer = pd.ExcelWriter('paris_data.xlsx')
paris_data.to_excel(writer)
writer.save()

writer = pd.ExcelWriter('global_data.xlsx')
global_data.to_excel(writer)
writer.save()


print('End')