csv 文件读写处理，JSON文件读写处理，Excel

Python基础学习笔记DAY13

csv 文件读写处理

1. csv文件
   逗号分隔值（Comma-Separated Values，CSV，有时也称为字符分隔值，因为分隔字符也可以不是逗号），其文件以纯文本形式存储表格数据（数字和文本）。
2. 读取csv文件代码示例

import csv
from collections import namedtuple

//从数据库中读取csv文件
def csv_read()
    with open('product.csv',encoding = 'utf8') as f:
        reader = csv.reader(f)
        headers = next(reader)
        print(headers)
        for row in reader:
            print('编号{}\t产品{}\t单价{}'.format(row[0],row[1],row[3]))


//从数据库中以namedtuple方式读取csv文件
def csv_read_by_namedtuple():
    with open('product.csv', encoding = 'utf8') as f:
        reader = csv.reader(f)
        headers = next(reader)
        Row = namedtuple('Row', headers)
        for r in reader:
            row = Row (*r)
            print(row)
            for row in reader:
                print(row)


//从数据库中以字典表方式读取csv文件
def csv_read_by_dict():
    with open('product.csv',encoding = 'utf8') as f:
        reader = csv.DictReader(f)


if __name__ =='__main__':
    csv_read()

3. 写入csv文件代码示例

import csv
def csv_write():
    headers = ["编号","课程","讲师"]
    rows = [
        (1,'Python','Eason'),
        (2,'C#,'Eason'),
        (1,'.NET','Eason')
    ]
    with open('mu_course.csv','w',encoding = 'utf8',newline = '' ) as f:
        writer = csv.writer(f)
        writer.writerow(headers)
        writer.writerows(rows)


def csv_writer_dict()
    headers = ['ID','Title','Org','Url']
    rows = [
    {'ID':1, 'Title': 'Python', 'Org': 'Youpinketang','Url':'uke.cc'}
    ]
    with open ('my_course2.csv','w', encoding = 'utf8') as f:
    writer = csv.DictWriter(f,headers)
    writer.writeheader()
    writer.writerows(rows)


if __name__ =='__main__':
    csv_writer()

JSON文件读写处理

1. JSON(JavaScript Object Notation) 是一种轻量级的数据交换格式。 易于人阅读和编写。同时也易于机器解析和生成。
2. 写入JSON文件代码示例

import json


def jason_basic()
    data = {
        "ID":1
        "课程":"优品课堂"
        "单价":"98.00"
    }
    json_str = json.dumps(data)  //写在字符串里
    json_data = json.loads(json_str)


def json_writer_filr():
    data = {
        "ID":1
        "课程":"优品课堂"
        "单价":"98.00"
    }
    with open('data.json','w',encoding='utf8') as f:
        json.dump(data,f)   //不是写在字符串，而是直接写在文档，所以dump后不用s

3. 读取json文件

import json


def json_read_filr():
    with open('data.json','r',encoding = 'utf8') as f:
        data  = json.load(f)
        print(data)

4. json和python语法区别

Python	Json
False	false
True	true
None	none

Excel

1. 从Excel问价中读取信息

import xlrd


def xl_read()
    book = xlrd.open_workbook('product.xls')
    for sheet in book.sheets():
        print(sheet.name)


def xl_read_dada():
    book = xlrd.open_workbook('product.xls')
    sheet = book.sheet_by_name("Product")
    print('工作簿':{}.format(sheet.name))
    print('数据行数':{}.format(sheet.rows))
    print('产品数据')
    for i in range(sheet.rows):
        print(sheet.row_values(i))  //获取索引指定的数据行