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.

Software ==> Python  (28 exercises)
Version ==> Latest version
Topic ==> Files and folders  (3 exercises)
Level ==> Harder than average
Subject ==> Python training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

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:

Shopping 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:

April shopping data

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.

List of shopping

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!

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post