Exporting table from SQLite database to Excel and vice versa using Google colab

00:00 Introduction
01:08 Downloading from Github with link to open the script in Colab platform
01:49 Downloading the SQLite sample database to Colab platform
02:46 Connecting to SQLite Database using sqlite3 in Colab
03:19 Listing all the tables available inside SQLite database in Colab platform
04:52 Displaying first five records of sample student table of SQLite database
05:47 Importing Pandas library
06:30 Creating Pandas DataFrama by using SQLite table by using read_sql
08:10 Creating Excel file using the Pandas DataFrame by to_excel
09:13 Deleting the sample student table in SQLite database.
10:17 Creating Pandas DataFrame from a Excel file by using read_excel
11:43 Creating SQLite table from the Pandas DataFrame by using to_sql
13:02 Checking the new table by displaying first 5 recods

#Python #Colab #Github #ExportingData #SQLite #Excel #ImportingExcel

Download source code here

List of tutorials