从嵌套字典到CSV文件 [英] From Nested Dictionary to CSV File

问题描述

我有嵌套的字典（长度> 70.000）：

I have nested dictionary (with length > 70.000):

users_item = {
    "sessionId1": {
        "12345645647": 1.0, 
        "9798654": 5.0 

    },         
    "sessionId2":{
        "3445657657": 1.0

    },
    "sessionId3": {
        "87967976": 5.0, 
        "35325626436": 1.0, 
        "126789435": 1.0, 
        "72139856": 5.0      
    },
    "sessionId4": {
        "4582317": 1.0         
    }
......
}

我想从嵌套字典中创建CSV文件，结果如下：

I want create CSV file from my nested dictionary, my result will look like:

sessionId1 item rating
sessionId1 item rating
sessionId2 item rating
sessionId3 item rating
sessionId3 item rating
sessionId3 item rating
sessionId3 item rating
.......

我发现了这篇文章：将嵌套字典转换为CSV表

它与我的问题类似，但是当我尝试所有答案时它不起作用， pandas 库内存不足

It's similar to my question but it's not working when I try all answers, pandas library run out of memory

如何使用数据制作CSV文件？

How I can make CSV file with my data?

推荐答案

只需遍历字典并使用 Python csv编写器写入csv文件。

Just loop through the dictionary and use the Python csv writer to write to the csv file.

with open('output.csv', 'w') as csv_file:
    csvwriter = csv.writer(csv_file, delimiter='\t')
    for session in users_item:
        for item in users_item[session]:
            csvwriter.writerow([session, item, users_item[session][item]])

这篇关于从嵌套字典到CSV文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！