Python

라이브러리 및 옵션 설정¶ In [2]: import os import numpy as np import pandas as pd import seaborn as sns import matplotlib as mpl import matplotlib.pyplot as plt %matplotlib inline mpl.rc('font', family ='AppleGothic') #맥용 폰트 설정 #mpl.rc('font', family ='Malgun Gothic') #윈도우용 폰트 설정 plt.rcParams['axes.unicode_minus'] = False #마이너스 숫자가 잘 나오도록 설정 from IPython.display import set_matplotlib_formats set_matplotli..

라이브러리 및 옵션 설정¶ In [1]: import os import numpy as np import pandas as pd import seaborn as sns import matplotlib as mpl import matplotlib.pyplot as plt %matplotlib inline mpl.rc('font', family ='AppleGothic') #맥용 폰트 설정 #mpl.rc('font', family ='Malgun Gothic') #윈도우용 폰트 설정 plt.rcParams['axes.unicode_minus'] = False #마이너스 숫자가 잘 나오도록 설정 from IPython.display import set_matplotlib_formats set_matplotli..

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..

In [1]: import os import numpy as np import pandas as pd In [2]: os.getcwd() #현재 디렉토리 확인 Out[2]: '/Users/limjongjun/Desktop/JayJay/Growth/Python/Class101_Pandas' In [3]: df1 = pd.read_csv('01_Contract_Data.csv') df1.head() Out[3]: Index Member_ID Sales_Type Contract_Type Channel Datetime Term Payment_Type Product_Type Amount_Month Customer_Type Age Address1 Address2 State Overdue_count O..