I am new to both Python & R. I am not sure which to use for the following project:
In an excel file, I have a list of the paths of CSV files.
Starting from Row 1 in the Excel, I want to
a. open the CSV file,
b. use Regex expression to find some values in the CSV file,
c. evaluate the values,
d. output the result into the Excel file.
Then move to Row 2 and repeat the above. The above steps are repeated until the last used row in the Excel file.
What are the pros & cons of using R or Python for the above? Eg, for Regex expression is it better to use Python or R
Thank you in advance!