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
Last activity: Mar 29, 2023, 12:07 PM