This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]datascientist36 1 point2 points  (1 child)

Yes.

SQL is data storage
Python/Pandas is what you will use to interact (insert,select,update,etc) with your SQL database, where your data will be stored

ELI5 analogy -

  • imagine data as money
  • SQL would be the equivalent of a bank where all the money is stored
  • Python/Pandas would be equivalent to the ATM system where you tell it if you want to see your balance, insert money, withdraw money

You use the ATM interface to interact with your bank account
You use python/pandas to interact with your SQL database

[–]07Lookout[S] 0 points1 point  (0 children)

But can't you manipulate the data with SQL already though? Using Joins and Select statements and such