import csv with two rows as header
Hi, I'm working with relative large csv files (±150MB), The files start with two rows that need to be combined as the column header. I wrote a script that loop through each column and set the column name to the current name + the value of the first row. The problem it is running very slow, sometimes I need to wait ±10min for changing the name of 4000 columns. It is somehow depends on the file siz...