CSV练习

#!/usr/bin/python

-- coding: utf-8 --

import sys

print(sys.getdefaultencoding())

f = open(“cs.csv”, “a+”)

f.write(“hello”) # 写f.write(str) 字符串类型

f.seek(3, 0)

content = f.read() # 因为光标 文件的末尾 ,从末尾读取内容

print(content)

f.close()

f = open(“cs.csv”,“a+”, encoding=‘UTF-8’)

f.write(“品牌”) # 写f.write(str) 字符串类型

f.seek(0,0) # 光标移动开头

content = f.read() # 因为光标 文件的末尾 ,从末尾读取内容

print(content)

f.close()

import csv

exampleFile = open(‘cs.csv’, encoding=‘UTF-8’)# 假设csv文件已在工作目录下

exampleReader = csv.reader(exampleFile)

# print(list(exampleReader))

# 也可以用for循环从Reader对象中读取数据, 每一行都是一个列表。

for row in exampleReader:

print(row)

import csv

# 使用数字和字符串的数字都可以

datas = [[‘name’, ‘age’],[‘Bob’, 14],[‘Tom’, 23],[‘Jerry’, ‘18’]]

with open(‘cs.csv’, ‘a+’, newline=’’) as f:

writer = csv.writer(f)

# for row in datas:

# writer.writerow(row)

# 还可以写入多行

writer.writerows(datas)

import json

data =
{
‘name’: ‘ACME’,
‘shares’: 100,
‘price’: 542.23
}

json_str = json.dumps(data)

data = json.loads(json_str)

print(data)

with open(‘data.json’, ‘w’) as f:

json.dump(data, f)

# Reading data back

with open(‘data.json’, ‘r’) as f:

data = json.load(f)

import json

with open(‘data.json’, ‘w’) as f:
data = json.dump(data, f)

print(data[‘rating’])