import pandas as pd
# DataFrame 1: Produtos, categorias e preços
df1 = pd.DataFrame({
"product": ["Laptop", "Smartphone", "Tablet"],
"category": ["Electronics", "Electronics", "Electronics"],
"price": [1200, 800, 300]
})
# DataFrame 2: Produtos, categorias e preços
df2 = pd.DataFrame({
"product": ["Laptop", "Smartwatch", "Camera"],
"category": ["Electronics", "Wearables", "Photography"],
"price": [1200, 250, 600]
})
# UNION ALL
union_all_df = pd.concat([df1, df2], ignore_index=True)
print("UNION ALL - Produtos:")
print(union_all_df)