nrm176/hannari-python-11.md

Created August 12, 2020 15:51

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nrm176/e55590137b340b3ef4d2be7227d5c1e3.js"></script>
Save nrm176/e55590137b340b3ef4d2be7227d5c1e3 to your computer and use it in GitHub Desktop.

Download ZIP

hannari-python-11

Raw

hannari-python-11.md

https://www.kaggle.com/nerimplo111/lesson-pork/

df_2 = pd.read_sql("SELECT Year||month year_month, Country, Value total from ym_2018_2020 WHERE hs6 IN ('281111') AND Year >= 2019 ORDER BY ym DESC" ,conn)
plt.rcParams['figure.figsize']=(20,10)
sns.barplot(x="year_month", y="total", 
            data=df_2[ (df_2['Country'] == 103) ].groupby('year_month').sum().reset_index()).set_title('韓国へのエッチングガス輸出金額')