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
https://www.plus2net.com/python/sqlit...

List of tutorials
   • Python tutorial to manage SQLite file...  



Web site: www.plus2net.com
YouTube:    / @plus2net1  
Facebook:   / plus2net  
Instagram:   / plus2net.in  
LinkedIn:   / plus2net  
Write to us https: //www.plus2net.com/contactus.php