import pandas as pd, numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
%matplotlib inline
from jupyterthemes import jtplot
# oceans16 | grade3 | chesterish | onedork | monokai | solarizedl
jtplot.style('solarized-light')
from os import listdir
from os.path import isfile, join
onlyfiles = [f for f in listdir('./db/') if isfile(join('./db/', f)) if '.ipynb' not in f]
dfs=[]
for i in onlyfiles:
df=pd.read_csv('db/'+i)
df['data']=i
dfs.append(df)
d=pd.concat(dfs)
d.index.name='Nr'
d.to_csv('all.csv')
fig,ax=plt.subplots(1,1,figsize=(14,3))
sns.stripplot(x=u' Judete', y=' Valoare', hue=' Sexe', split=True,\
data=df[df[' Ani']==' Anul 2017'], ax=ax, jitter=True)
plt.show()
dg=df.set_index(' Localitati ')
for i in dg.index.unique():
dg.loc[i].to_csv('data/'+i+'.csv')
import json
file('locs.json','w').write(json.dumps(list(dg.index.unique())))