Hi
I am new to Python.
I would like to know if Python can do the following
1) In an excel file, I have a list of the paths of CSV files.
2) Starting from Row 1 in the Excel, I want Python 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.
3) Then Python will move to Row 2 and repeat the above. The above steps are repeated until the last used row in the Excel file.
First of all, can Python open the CSV file based on the path in the Excel?
Thank you
I am new to Python.
I would like to know if Python can do the following
1) In an excel file, I have a list of the paths of CSV files.
2) Starting from Row 1 in the Excel, I want Python 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.
3) Then Python will move to Row 2 and repeat the above. The above steps are repeated until the last used row in the Excel file.
First of all, can Python open the CSV file based on the path in the Excel?
Thank you