In [4]:
import pandas as pd
df = pd.read_csv('Count by district[D3js circlegroup].tsv', sep='\t')
In [8]:
df['District'][0]
Out[8]:
In [15]:
with open('outfile.txt', 'w') as f:
f.write('[\n')
for i in range(df.shape[0]):
data_to_write = "{\"death_count\": %s, \"district\": \"%s\", \"group\" : \"group 1\"}" % (int(df['count_sum'][i]), df['District'][i])
f.write(data_to_write + ',\n')
f.write(']\n')
f.close()
In [ ]: