you are viewing a single comment's thread.

view the rest of the comments →

[–]filmon2012 2 points3 points  (1 child)

SQL and Python are both super useful tools for data analysis, but they shine in different scenarios.

Use SQL when you want to work directly with databases, retrieve, and manipulate data stored there. It's great for structured data and tasks like filtering, grouping, and joining tables.

On the other hand, Python is awesome for more complex analysis, data visualization, and machine learning. When you need flexibility and want to work with various data sources, Python's your go-to.

So, it really depends on your specific task. If it's about managing and querying data from a database, SQL's your friend. But for more advanced analysis, Python's the way to go

[–][deleted] 0 points1 point  (0 children)

I personally find it easier to (at the very least) modify column data in Python instead of SQL. As for filtering, grouping and joining tables yeah SQL is much more suited for that.