w3resource

Python CSV File Reading and Writing - Exercises, Practice, Solution

Python CSV File Reading and Writing [11 exercises with solution]

[An editor is available at the bottom of the page to write and execute the scripts.]

1. Write a Python program to read each row from a given csv file and print a list of strings. Go to the editor
Click me to see the sample solution

2. Write a Python program to read a given CSV file having tab delimiter. Go to the editor
Click me to see the sample solution

3. Write a Python program to read a given CSV file as a list.
Click me to see the sample solution

4. Write a Python program to read a given CSV file as a dictionary. Go to the editor
Click me to see the sample solution

5. Write a Python program to read a given CSV files with initial spaces after a delimiter and remove those initial spaces. Go to the editor
Click me to see the sample solution

6. Write a Python program that reads a CSV file and remove initial spaces, quotes around each entry and the delimiter. Go to the editor
Click me to see the sample solution

7. Write a Python program to read specific columns of a given CSV file and print the content of the columns. Go to the editor
Click me to see the sample solution

8. Write a Python program that reads each row of a given csv file and skip the header of the file. Also print the number of rows and the field names. Go to the editor
Click me to see the sample solution

9. Write a Python program to create an object for writing and iterate over the rows to print the values. Go to the editor
Click me to see the sample solution

10. Write a Python program to write a Python list of lists to a csv file. After writing the CSV file read the CSV file and display the content. Go to the editor
Click me to see the sample solution

11. Write a Python program to write a Python dictionary to a csv file. After writing the CSV file read the CSV file and display the content. Go to the editor
Click me to see the sample solution

Python Code Editor:

More to Come !

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.

Test your Python skills with w3resource's quiz



Python: Tips of the Day

Getting the last element of a list:

some_list[-1] is the shortest and most Pythonic.

In fact, you can do much more with this syntax. The some_list[-n] syntax gets the nth-to-last element. So some_list[-1] gets the last element, some_list[-2] gets the second to last, etc, all the way down to some_list[-len(some_list)], which gives you the first element.

You can also set list elements in this way. For instance:

>>> some_list = [1, 2, 3]
>>> some_list[-1] = 5 # Set the last element
>>> some_list[-2] = 3 # Set the second to last element
>>> some_list
[1, 3, 5]

Note that getting a list item by index will raise an IndexError if the expected item doesn't exist. This means that some_list[-1] will raise an exception if some_list is empty, because an empty list can't have a last element.

Ref: https://bit.ly/3d8TfFP