Import Records From CSV File (or any data file) to SQL Server (or any database system) With Python HD

In this Python tutorial, we are going to learn how to import records from a CSV file to Microsoft SQL Server. The script can also be adapted to import dataset from an Excel file, a text file, or any data file as we will be reading the dataset into a pandas dataframe first. And the database system is not limited to just SQL Server, it can be MySQL, Oracle, or any other database systems. I am using SQL Server because this is the database system I know the best. Source Code: https://learndataanalysis.org/import-records-from-csv-file-or-any-data-file-to-sql-server-or-any-database-system-with-python/ Buy Me a Coffee? Your support is much appreciated! ---------------------------------------------------------------------------------------------------------------- PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Patreon: https://www.patreon.com/JieJenn Check out Kit → https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=jiejenn&utm_content=description-only Dataset Used: https://data.austintexas.gov/Transportation-and-Mobility/Real-Time-Traffic-Incident-Reports/dx9v-zd7x Timestamp: 00:00 - Tutorial info 00:45 - Data source used in this video 02:15 - Table Creation SQL Statement 02:35 - Writing automation script in Python 03:20 - How to find out what drivers are available on your PC 03:45 - Get SQL Server Server Name 04:45 - Import data to DataFrame 07:45 - Data clean up 14:52 - Convert DataFrame object to List object 16:00 - Create connection string 19:45 - Create connection object 22:00 - Create cursor object 25:35 - Run the script for testing. Support my channel so I can continue making free contents ---------------------------------------------------------------------------------------------------------------- By shopping on Amazon → https://amzn.to/2JkGeMD More tutorial videos on my website → https://LearnDataAnalysis.org Follow Me on Facebook → https://www.facebook.com/Learn-Data-Analysis-101284561779059 Business Inquiring: YouTube@LearnDataAnalysis.org Tags: #SQLServer #Python