In [1]:
import pymysql
In [3]:
import MySQLdb # $ pip install mysqlclient
In [2]:
db = pymysql.connect(
"db.fastcamp.us", # DATABASE_HOST
"root", # DATABASE_USERNAME
"dkstncks", # DATABASE_PASSWORD
"world", # DATABASE_NAME
)
In [5]:
df = pd.read_sql("SELECT * FROM Country;", db)
df.head()
Out[5]:
In [6]:
db = pymysql.connect(
"db.fastcamp.us", # DATABASE_HOST
"root", # DATABASE_USERNAME
"dkstncks", # DATABASE_PASSWORD
"sakila", # DATABASE_NAME
)
In [8]:
df = pd.read_sql("SELECT * FROM customer;", db)
In [9]:
df.head()
Out[9]:
In [11]:
df = pd.read_sql("SHOW TABLES;", db)
In [15]:
df.head()
Out[15]:
In [12]:
#밖에다가 data라는 폴더 만들기
def save_to_csv(table_name):
table_df = pd.read_sql("SELECT * FROM {table_name};".format(table_name=table_name), db)
table_df.to_csv("./data/{table_name}.csv".format(table_name=table_name))
In [14]:
df["Tables_in_sakila"].apply(save_to_csv)
Out[14]: