I have a large number of CSV files, some which do not have headers. I need to identify there column names and map those columns to the correct columns in the target table. Is this a good solution? If yes, please advice on how to go about doing it since I am new to text mining, if no then please suggest some other work around.
Do you really want to have uncertainty as to whether you're even processing the correct data? I feel like this is something that you should either do manually, or reject datasets that don't tell you what they contain.