SQLite

In [1]: import os import numpy as np import pandas as pd import sqlite3 In [2]: os.getcwd() #현재 디렉토리 확인 Out[2]: '/Users/limjongjun/Desktop/JayJay/Growth/Python/Class101_Pandas' DB에 있는 데이터 가져오기¶ In [150]: connection = sqlite3.connect('sample.db') In [151]: query1 = "SELECT * FROM sqlite_master" #sqlite_mastr : DB내의 테이블 정보 In [152]: pd.read_sql_query(query1, connection) Out[152]: type name..