I stopped writing throwaway scripts for messy CSVs and just use SQL now
Someone sends you a CSV. Then a folder of CSVs. Then a CSV that's actually tab-separated but named .csv, with a stray header row and a column that's a number on most rows and the string N/A on the rest. For years my answer to "can you pull a quick number out of this?" was a throwaway Python script.
โก
Key Insights
10 editorial insights.
AiFeed24 Teamยทโฑ 1 min readยทNews
Deep Analysis
Multi-Source Intelligence
Tags:#cloud
Found this useful? Share it!