David SQL — DataLab

DataFrameas

customers_csv_csv

variable

SELECT *
FROM 'main/orders_csv.csv' AS o
JOIN 'main/customers_csv.csv' AS c ON o.customer_id = c.customer_id
JOIN 'main/products_csv.csv' AS p ON o.product_id = p.product_id

DataFrameas

customers_csv_csv

variable

SELECT * FROM 'customers_csv.csv'

DataFrameas

orders_csv_csv

variable

SELECT * FROM 'orders_csv.csv'

DataFrameas

products_csv_csv

variable

SELECT * FROM 'products_csv.csv'

import pandas as pd
customers_csv = pd.read_csv('customers_csv.csv')
customers_csv

import pandas as pd
orders_csv = pd.read_csv('orders_csv.csv')
orders_csv

import pandas as pd
products_csv = pd.read_csv('products_csv.csv')
products_csv

DataFrameas

orders_csv_csv

variable

SELECT * FROM 'orders_csv.csv'

DataFrameas

products_csv_csv

variable

SELECT * FROM 'products_csv.csv'