Data Science Jumpstart with 10 Projects Transcripts
Chapter: Project 9: SQL / Database Integration
Lecture: Create a database table with Pandas using to_sql
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Once I've got a connection, we can start manipulating a database, doing things with it.
0:06
Let's create a table. I'm going to create a table in SQLite. I'm going to say connect to SQLite,
0:13
and look at this, I'm using pandas here, and I'm going to say, hey pandas, I want you to make a
0:20
table called ALTA, and if it exists in there, I want you to replace it. Don't stick the index in
0:25
there, and then we'll close our connection. Once you have data in pandas, relatively easy to stick it into a SQL table.