{"blog_url":"https://kentarowada.hatenablog.com/","description":"MySQL\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059 \"\"\"Get data from MySQL with pandas library.\"\"\" import MySQLdb import pandas.io.sql as psql con = MySQLdb.connect(db='work', user='root', passwd='') # DB\u63a5\u7d9a sql = \"\"\"SELECT product_id, product_nm, product_features FROM electronics\"\"\" df = psql.read_sql(sql, con) # pandas\u306eDataFrame\u306e\u5f62\u3067\u30c7\u30fc\u2026","blog_title":"Blog: kentaro.wada","image_url":null,"provider_url":"https://hatena.blog","author_name":"kentarowada","url":"https://kentarowada.hatenablog.com/entry/2014/07/22/003944","title":"python+pandas\u3067\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u3092\u6271\u3046\u3068\u304d\u306e\u30e1\u30e2","published":"2014-07-22 00:39:44","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkentarowada.hatenablog.com%2Fentry%2F2014%2F07%2F22%2F003944\" title=\"python+pandas\u3067\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u3092\u6271\u3046\u3068\u304d\u306e\u30e1\u30e2 - Blog: kentaro.wada\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","provider_name":"Hatena Blog","categories":["Python","Data Mining"],"type":"rich","height":"190","width":"100%","author_url":"https://blog.hatena.ne.jp/kentarowada/"}