오우진

테이블 생성코드 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',..

테이블 생성코드 Create table If Not Exists Sales (sale_id int, product_id int, year int, quantity int, price int) Create table If Not Exists Product (product_id int, product_name varchar(10)) Truncate table Sales insert into Sales (sale_id, product_id, year, quantity, price) values ('1', '100', '2008', '10', '5000') insert into Sales (sale_id, product_id, year, quantity, price) values ('2', '100', '200..