1. Learn
    2. /
  2. Courses
    3. /
  3. Python Toolbox
Connected

Exercise

Processing data in chunks (1)

Sometimes, data sources can be so large in size that storing the entire dataset in memory becomes too resource-intensive. In this exercise, you will process the first 1000 rows of a file line by line, to create a dictionary of the counts of how many times each country appears in a column in the dataset.

The csv file 'world_dev_ind.csv' is in your current directory for your use. To begin, you need to open a connection to this file using what is known as a context manager. For example, the command with open('datacamp.csv') as datacamp binds the csv file 'datacamp.csv' as datacamp in the context manager. Here, the with statement is the context manager, and its purpose is to ensure that resources are efficiently allocated when opening a connection to a file.

If you'd like to learn more about context managers, refer to the DataCamp course on Importing Data in Python.

Instructions

100 XP
  • Use open() to bind the csv file 'world_dev_ind.csv' as file in the context manager.
  • Complete the for loop so that it iterates 1000 times to perform the loop body and process only the first 1000 rows of data of the file.