Python | Files and folders exercise | Collate monthly shopping lists from different files
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
You can learn how to do this exercise if you attend the course listed below!
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
The folder above contains the following files:
There are 4 CSV files containing records of how much you spent in the first 4 months, and one text file you want to ignore.
Here for example is what the first file (April.csv) contains:
What you spent in April.
Write a program to loop over all of the CSV files in the folder. Your program should open each CSV file in turn, read in its lines (missing out the header row) and then add them to a list.
Finally your program should print out the accumulated contents (it's acceptable to show the months in alphabetical order).
To store each month name, you'll have to first extract it from the path for each CSV file.
When you've got this working, close your program down!