Tag: data_cleanup
-
How to Dynamically Format Pandas DataFrame Columns to be Database and Parquet Ready
Pandas allow for almost anything as a column header and I’ll show you how to get your columns parquet and database ready.
-
Why does my cell show a bunch of #### in Excel?
Cells showing up with a bunch of #’s is typically the result of cell content that is too large to display. Let’s check out a few solutions to fix this.
-
Cleaning up String Data in MySQL for Better Exporting
Data stored as strings can be problematic if you are exporting raw data from MySQL and using Excel or another application to analyze the data.
-
How to Combine Multiple CSV Files into One
Easily combine multiple CSV files with the Terminal on Mac.
-
Split a column with a delimiter in SQLite
Let’s say you have a column with someone’s full name stored in the format of “LastName, FirstName” and you would rather have two columns – one with the first name and one with the last name. The below code to split out the names in your results window.
-
Cleaning up non-ISO Dates in SQLite
SQLite doesn’t have a date storage class which makes working with dates a bit tricky. You’ll have to store the data as ‘Text’. You can read more about that here.