Posted 6 days ago
136.32K followers
5.56K views
300 likes
26 comments
13 shares
You don't need a database to run SQL in Python. Every time you want to query a CSV, you're either loading it into pandas and chaining .groupby().agg()... or setting up an entire database server. Here's the shortcut: Install DuckDB. Write raw SQL directly on any CSV or Parquet file. No server. No imports. No setup. Just SQL on files - and it's 10x faster than pandas on large data. Comment "SQL" for the full cheat sheet and save this before your next analysis. #PythonForDataScience #DuckDB #SQLTips #DataAnalyticsTips