I frequently read large .csv files with many columns > 300.
I only need ~ 50 of the columns. Because the names of the columns are from a bad formatted excel-file I need to locate them by numbers. It is awkward to locate them by counting them from the beginning in a text-file viewer.
Any ideas how I can improve this process ? A viewer which gives automatically the number of the columns?
Working with RStudio on Mac.