Post processing of data in a csv file using script
I have a folder with mutiple csv files having similar data structure whose data I need to process and store the results in a new file.
Each csv file has 2 columns, I need to process the data in the second column as follows:Name the second column as itemsPerform the following operation on all rows creating a new column x with the following formula :36 + -19.5 * :items+ 49.99 *:items* :items* :items...