ÆÇ´Ù½º·Î postgresql¿¡ ÀúÀåÇÏ¿© Àоî¿À¸é Å×À̺íÀÇ Çü½ÄÀ̳ª ³»¿ëÀÌ ´Ù¸¨´Ï´Ù.
¾î¶»°Ô °íÃÄ¾ß ÇÒÁö ¸ð¸£°Ú³×¿ä. ¿ÕÃʺ¸ ÀÔ´Ï´Ù. ¤Ì¤Ì
¾Æ·¡´Â µ¥ÀÌÅÍ ÇÁ·¹ÀÓ ÀÔ´Ï´Ù. data_sch
µ¥ÀÌÅÍÇÁ·¹ÀÓ ¿øº»¿¡´Â Ä÷³ À̸§ÀÌ ÁöÁ¤µÇ¾î ÀÖ½À´Ï´Ù.
0 2019-10-01 a 1234 18:00 124 09:36 È«±æµ¿
1 2019-10-01 B 3456 04:00 153 16:47 ±è¾Æ¹«
2 2019-10-01 C 4567 07:00 2462 17:33 ¹Ú¾Æ¹«
.
.
.
111row x 9columns
À¥Å©·Ñ¸µÀ¸·Î À§¿Í °°Àº µ¥ÀÌÅ͸¦ ¼öÁýÇÏ¿© ÆÇ´Ù½º·Î µ¥ÀÌÅÍ ÇÁ·¹ÀÓÀ» ¸¸µé¾ú´Âµ¥¿ä.
±×¸®°í postgresql µ¥ÀÌÅÍ º£À̽º¿¡ ÀúÀåÀ» ÇÏ¿´´Âµ¥¿ä.
µ¥ÀÌÅͺ£À̽º¿¡¼ ÀÐ¾î µéÀÌ´Ï ¾Æ·¡¿Í °°ÀÌ Ç¥½Ã°¡ µË´Ï´Ù.
1st 2nd 3rd
0 d 2015-08-31 17
1 d 2015-08-26 18
2 c 2015-08-27 1
3 b 2015-08-29 15
4 a 2015-09-01 15
.
.
.
1000row x 3columns
ÄÚµùÀº ¾Æ·¡¿Í °°½À´Ï´Ù.
data_sch´Â ÆÇ´Ù½º µ¥ÀÌÅÍÇÁ·¹ÀÓÀÔ´Ï´Ù.
engine = sqlalchemy.create_engine("postgresql://id:pw@localhost/sample_db") con = engine.connect()
# Verify that there are no existing tables print(engine.table_names())
table_name = 'data_sch' df.to_sql(table_name, con, schema='public', if_exists='replace', index=False, index_label='None', chunksize=10000)
df = pd.read_sql_query('select * from data_sch',con=engine) con.close()
print(df) |
Mysql ·Î ¹Ù²Ù°í Àß ÇØ°á µÆ½À´Ï´Ù