Sample Header Ad - 728x90

Extracting columns with similar name from two different csv files

-3 votes
2 answers
474 views
I have two different csv files ,one file contain extended columns names while the other contain a shortcut of the same columns names. For example : csv file 1 is :
gender,aciclovir drug,aclidinium bromide abc,acenocoumarol drdd
male,2008,2009,2009
csv file 2 is :
gender,aciclovir,aclidinium bromide,ajmaline
male,2008,2009,2010
Now i want to extract columns from file 1 which have a common word with columns from file 2. desired out put in my example :
gender,aciclovir drug,aclidinium bromide abc
male,2008,2009
Asked by Solomon123 (131 rep)
Mar 27, 2023, 07:08 PM
Last activity: Mar 29, 2023, 12:07 PM