How to Remove Duplicates from a CSV File
Data Engineer at CSV Explorer
CSV Explorer lets you open big CSV files and search them. CSV Explorer also has several features to find and remove duplicate data from a CSV read more
CSV Quick Fixes
Data Engineer at CSV Explorer
We're about to hit 5 billion rows loaded into CSV Explorer for analysis. I wish I could say all those rows were parsed and loaded automatically from CSV files straight into PostgreSQL, but we've seen our fair share of the quirks and errors of CSV formatting. I remember a late night copying a CSV into PostgreSQL and being stumped by ERROR invalid input syntax for date '4/31/2017' read more
How to Open Big CSV Files
Data Engineer at CSV Explorer
CSV files are chunks of text used to move data between spreadsheets, databases, and programming languages. Spreadsheet software, like Excel, can have a difficult time opening very large CSVs. I’ll explain why large CSVs are difficult to work with and outline some tools to open big CSV files read more