filmov
tv
Greg Reda - Translating SQL to pandas. And back.
Показать описание
View slide presentation here:
PyData NYC 2014
SQL is still the bread-and-butter of the data world, and data analysts/scientists/engineers need to have some familiarity with it as the world runs on relational databases.
When first learning pandas (and coming from a database background), I found myself wanting to be able to compare equivalent pandas and SQL statements side-by-side, knowing that it would allow me to pick up the library quickly, but most importantly, apply it to my workflow.
This tutorial will provide an introduction to both syntaxes, allowing those inexperienced with either SQL or pandas to learn a bit of both, while also bridging the gap between the two, so that practitioners of one can learn the other from their perspective. Additionally, I'll discuss the tradeoffs between each and why one might be better suited for some tasks than the other. 00:00 Welcome!
00:10 Help us add time stamps or captions to this video! See the description for details.
PyData NYC 2014
SQL is still the bread-and-butter of the data world, and data analysts/scientists/engineers need to have some familiarity with it as the world runs on relational databases.
When first learning pandas (and coming from a database background), I found myself wanting to be able to compare equivalent pandas and SQL statements side-by-side, knowing that it would allow me to pick up the library quickly, but most importantly, apply it to my workflow.
This tutorial will provide an introduction to both syntaxes, allowing those inexperienced with either SQL or pandas to learn a bit of both, while also bridging the gap between the two, so that practitioners of one can learn the other from their perspective. Additionally, I'll discuss the tradeoffs between each and why one might be better suited for some tasks than the other. 00:00 Welcome!
00:10 Help us add time stamps or captions to this video! See the description for details.
1:12:16
Greg Reda - Translating SQL to pandas. And back.
0:28:00
Greg Reda: Why 'data informed' beats 'data driven
0:01:22
Greg Reda CPA SAS70 /SSAE16 Expert
0:17:42
SQL vs Python Pandas
0:08:35
From SQL to Pandas, Getting Over the Hump
0:26:54
First Steps to Transition from SQL to Pandas | Katarzyna Rachuta @ PyBay2018
0:14:01
From SQL to Pandas
0:01:01
Write SQL Queries On Python | Pandas Data Frame 😃🔥
0:40:03
Let's SQL Like It's 1992! - James Powell
0:13:43
Python driver for SQL server
0:06:20
How to Use SQL and Pandas to Extract Data From a MySQL Database
0:53:55
Pandas vs SQL: Battle of the data tools
0:09:44
Bistra Dilkina, CompSust-2017 Opening Remarks
0:08:48
Pandas important 3 functions
0:43:37
Ville Tuulos - How to Build a SQL-based Data Warehouse for 100+ Billion Rows in Python
0:06:25
Read My-SQL table in Python Pandas (How to) | tutorial for beginners
0:12:40
All Roads Lead To Pandas
0:14:26
Convert SQL Queries into Python Pandas | Part-1 | SQL to Python Conversion
0:10:00
Connecting to a SQL Database in Bottle Using SQLAlchemy
0:01:37
Python_ Load data into pandas from a MSSQL Server DB
0:20:52
Python SQLite3 database extract Pandas Dataframe convert to CSV | Python for Scott Episode 2
0:15:08
Experimente mit SQL Injection [Linux , python, UNION SELECT]
0:04:22
How to do a SQL Inner Join in Python (Pandas)
0:06:06
How to do a SQL Group By in Python (Pandas)
Комментарии