I need to do CSV parsing and I was wondering if this is possible with python and where I should go to learn how to code this script or get help.
Let's say I have a CSV file with 20 rows and 4 columns. I need to:
-Strip out the first five rows
-Strip out the last three rows
-Strip out the 2nd and 4th columns
-Convert the dates in the 3rd column from format DD-MM-YYYY to MMM-DD (so for example, a 14-05-1999 gets converted to May-14)
In the end, I'll have a CSV file with 12 rows and 2 columns, with one of the columns in a different date format.
If this is in fact possible, can someone please point me to some tutorials that would help me achieve this in the least time possible? THANKS SO MUCH!