Upload A CSV File (Or Any Data File) To SQLite Using Python
HTML-код
- Опубликовано: 22 авг 2024
- So this is a technique I use whenever I need to upload a data file into a SQLite database, and with this method, you are not limited to just CSV files, you can load a text file, JSON file, or load tables from a different database. In this video, I am going to show you how to load a CSV data file into a SQLite database using pandas.
📺 How to get started with SQLite database in Python: • How To Use SQLite Data...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩💻 Follow me on Linked: / jiejenn
🌳 Becoming a Patreon supporter: / jiejenn
✉️ Business Inquiring: RUclips@LearnDataAnalysis.org
#pandas #sqlite3 #sqlite #python #pythonprogramming
Super Awesome! God bless you!
thanks for the assist , sergeant Jenn
Glad to hear!
Jie, This video was exact and very beneficial. You have a new subscriber and I liked this well done video.
Thank you.
Amazing Video!! Clear and concise.
👍
love you brother and thanks for this
This is great. Thank you so much!!!
Hey this was enlightening subscribed, I am trying to wrap my mind around sql and I finally see how to save csv. But I am generally a beginner in programming, what would be the advantage of using SQLite over just a csv, access or pandas.
Thank you
Hello, I do not know if you will be reading this. I want to ask you how much this might differ from real-world scenarios Data Ingestion? I am currently self-teaching myself Python programming and Data Engineering and it is very hard to grasp the real-world tasks a data engineers may be working with on daily basis.
And thank for the short and informative tutorial.
Thank you! Just subscribed!
Thank you for subscribing!
Thank u bro!
Accomplishing so much with only a few lines of code.
facts, chatgbt gave me like 50 lines and it still didnt work but this worked and easy to understand
@@olorodeabayomi6998 how do I use or import this .db file in mysql workbench?