# Export simple query resultssuccess = export_csv( "SELECT * FROM employees", "exported_employees.csv")# Export filtered data with parameterssuccess = export_csv( "SELECT * FROM employees WHERE department = ? AND year = ?", "eng_2023.csv", params=('Engineering', 2023))# Returns: bool (True if successful)
# Load dataload_csv("sales", "sales_data.csv")# Analyze with SQLresults = execute_query(""" SELECT department, COUNT(*) as count, AVG(salary) as avg_salary FROM employees GROUP BY department HAVING count > 5 ORDER BY avg_salary DESC""")
Data Export:
Copy
# Export filtered and aggregated dataexport_csv(""" SELECT date_trunc('month', date) as month, SUM(amount) as total_sales FROM sales GROUP BY 1 ORDER BY 1""", "monthly_sales.csv")
Data Transformation:
Copy
# Load and transform dataload_csv("raw_data", "input.csv")execute_query(""" CREATE TABLE transformed AS SELECT id, UPPER(name) as name, ROUND(amount, 2) as amount, DATE_TRUNC('day', timestamp) as date FROM raw_data""")export_csv("SELECT * FROM transformed", "transformed.csv")
# Export simple query resultssuccess = export_csv( "SELECT * FROM employees", "exported_employees.csv")# Export filtered data with parameterssuccess = export_csv( "SELECT * FROM employees WHERE department = ? AND year = ?", "eng_2023.csv", params=('Engineering', 2023))# Returns: bool (True if successful)
# Load dataload_csv("sales", "sales_data.csv")# Analyze with SQLresults = execute_query(""" SELECT department, COUNT(*) as count, AVG(salary) as avg_salary FROM employees GROUP BY department HAVING count > 5 ORDER BY avg_salary DESC""")
Data Export:
Copy
# Export filtered and aggregated dataexport_csv(""" SELECT date_trunc('month', date) as month, SUM(amount) as total_sales FROM sales GROUP BY 1 ORDER BY 1""", "monthly_sales.csv")
Data Transformation:
Copy
# Load and transform dataload_csv("raw_data", "input.csv")execute_query(""" CREATE TABLE transformed AS SELECT id, UPPER(name) as name, ROUND(amount, 2) as amount, DATE_TRUNC('day', timestamp) as date FROM raw_data""")export_csv("SELECT * FROM transformed", "transformed.csv")