How to convert a dictionary to a dictionary of CSV files in Python

How to convert a dictionary to a dictionary of CSV files in Python.

Here is a step-by-step tutorial on how to convert a dictionary to a dictionary of CSV files in Python:

Step 1: Import the required libraries

To begin, you need to import the necessary libraries in order to work with dictionaries and CSV files in Python. You will need the csv module for handling CSV files.

import csv

Step 2: Define the dictionary

Next, you need to define the dictionary that you want to convert to CSV files. Make sure your dictionary has a clear structure and appropriate keys and values.

data = {
    'person1': {'name': 'John', 'age': 25, 'city': 'New York'},
    'person2': {'name': 'Jane', 'age': 30, 'city': 'Los Angeles'},
    'person3': {'name': 'Mike', 'age': 35, 'city': 'Chicago'}
}

Step 3: Convert the dictionary to CSV files

Now, let's convert the dictionary to a dictionary of CSV files. We will iterate through each key-value pair in the dictionary and create a separate CSV file for each entry.

for key, value in data.items():
    filename = key + '.csv'
    with open(filename, 'w', newline='') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=value.keys())
        writer.writeheader()
        writer.writerow(value)

In the above code, we use a for loop to iterate through each key-value pair in the dictionary. For each entry, we create a new CSV file with the key as the filename. We open the file in write mode and use the csv.DictWriter class to write the contents of the dictionary to the CSV file. We pass the fieldnames as the keys of the dictionary and use the writeheader() method to write the fieldnames as the header row in the CSV file. Finally, we use the writerow() method to write the values of the dictionary as a row in the CSV file.

Step 4: Test the code

To test the code, you can run it and check if the CSV files are created correctly. Each CSV file should have the corresponding key as the filename and contain the values from the dictionary as rows.

# Run the code

After running the code, you should see separate CSV files created for each entry in the dictionary.

That's it! You have successfully converted a dictionary to a dictionary of CSV files in Python. You can now use these CSV files for further analysis or processing.