python处理csv文件和csv字符串

-夏末微凉-

于 2019-11-20 19:42:31 发布

阅读量3.8k

点赞数

分类专栏： python 文章标签： csv python

本文链接：https://blog.csdn.net/qq_38000422/article/details/103169868

版权

python 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

import csv
import io
filename = 'index.csv'

s = """"小明","{""age"":12,""sex"":""men""}"
"小红","{""age"":143,""sex"":""women""}"
"""

with open(filename, 'r') as file:

    r = csv.reader(io.StringIO(s)) #处理字符串
    for line in r:
        print(line)

    r = csv.reader(file) #处理文件
    for line in r:
        print(line)


index.csv:
"小明","{""age"":12,""sex"":""men""}"
"小红","{""age"":14,""sex"":""women""}"

output:
['小明', '{"age":12,"sex":"men"}']
['小红', '{"age":143,"sex":"women"}']
['小明', '{"age":12,"sex":"men"}']
['小红', '{"age":14,"sex":"women"}']