CSV resource for SQL and Data professionals

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…

--

--

--

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging. Sign-up for my free newsletter here: openlamptech.substack.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

A step-by-step guide to creating a profitable EA

My Journey with Crio Winter of Doing ! (⌐■_■)

Complete Guide to HTML 5

Selenium and SQL combined- Top Premier league Players

Instructions for playing with the Monzo Receipts API when you don’t really know how to code!

Leakesville MS 601 936 5293

Enterprise Technical Debt: The Lurking Cancer of Your Distributed Systems

Octant with Metrics Server | Kubernetes Dashboard

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Joshua Otwell

Joshua Otwell

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging. Sign-up for my free newsletter here: openlamptech.substack.com

More from Medium

Using World Bank Data on Pandas for Beginners

How to Split Data with Delimiters into New Rows

Data Cleaning with Pandas

How to use row_number in SQL | SQL RANK() function | dense_rank SQL

How to use row_number in SQL | SQL RANK() function | dense_rank SQL