Most any data professional deals with CSV data at some point in their work-flow. Let’s face it, CSV’s are everywhere and are one of the more common data interchange formats. A common task SQL professionals have is loading CSV data into a database table. Or on the converse, extracting SQL data into a CSV file. I have written several posts about CSV’s with MySQL, PostgreSQL, and the Python pandas library, and still to this day, refer to many of those posts for help when working with CSV’s. This compilation post is for SQL and data professionals who would find value in this type of resource as well.
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
CSV Data: SQL, PHP, and Python Pandas Posts Compilation
- Export MySQL data to CSV with phpMyAdmin
- Import CSV file data into MySQL table with phpMyAdmin
- CSV to JSON with Python for MySQL upload
- Pandas and the python os module use case – appending source file information from CSV’s.
- Pandas concat() then to_sql() – CSV upload to PostgreSQL
- Pandas to SQL – importing CSV data files into PostgreSQL
- Basic CSV file import and exploration with Pandas – first steps.
- MySQL SELECT INTO Syntax Part 2 – Saving to OUTFILE with examples
- Import CSV file with MySQL Workbench
Feel free to let me know in the comments below if you find value in any of the above posts. I’d love to know your thoughts on them. Thanks for reading!
Like what you have read? See anything incorrect? Please comment below and thank you for reading!!!
A Call To Action!
Thank you for taking the time to read this post. I truly hope you discovered something interesting and enlightening. Please share your findings here, with someone else you know who would get the same value out of it as well.
Visit the Portfolio-Projects page to see blog post/technical writing I have completed for clients.
To receive email notifications (Never Spam) from this blog (“Digital Owl’s Prose”) for the latest blog posts as they are published, please subscribe (of your own volition) by clicking the ‘Click To Subscribe!’ button in the sidebar on the homepage! (Feel free at any time to review the Digital Owl’s Prose Privacy Policy Page for any questions you may have about: email updates, opt-in, opt-out, contact forms, etc…)
Be sure and visit the “Best Of” page for a collection of my best blog posts.
Josh Otwell has a passion to study and grow as a SQL Developer and blogger. Other favorite activities find him with his nose buried in a good book, article, or the Linux command line. Among those, he shares a love of tabletop RPG games, reading fantasy novels, and spending time with his wife and two daughters.
Disclaimer: The examples presented in this post are hypothetical ideas of how to achieve similar types of results. They are not the utmost best solution(s). The majority, if not all, of the examples provided, are performed on a personal development/learning workstation-environment and should not be considered production quality or ready. Your particular goals and needs may vary. Use those practices that best benefit your needs and goals. Opinions are my own.
One thought on “CSV resource for SQL and Data professionals”