오우진

테이블 생성코드 data = [[1, 100, 2008, 10, 5000], [2, 100, 2009, 12, 5000], [7, 200, 2011, 15, 9000]] sales = pd.DataFrame(data, columns=['sale_id', 'product_id', 'year', 'quantity', 'price']).astype({'sale_id':'Int64', 'product_id':'Int64', 'year':'Int64', 'quantity':'Int64', 'price':'Int64'}) data = [[100, 'Nokia'], [200, 'Apple'], [300, 'Samsung']] product = pd.DataFrame(data, columns=['product_id',..

테이블 생성코드 data = [[1, 'Wang', 'Allen'], [2, 'Alice', 'Bob']]person = pd.DataFrame(data, columns=['personId', 'firstName', 'lastName']).astype({'personId':'Int64', 'firstName':'object', 'lastName':'object'})data = [[1, 2, 'New York City', 'New York'], [2, 3, 'Leetcode', 'California']]address = pd.DataFrame(data, columns=['addressId', 'personId', 'city', 'state']).astype({'addressId':'Int64', 'pers..