python第十三节课

CSV文件读取

json

def json_basic():
    data = {
        "ID": 1,
        "课程": "python",
        "机构": "优品"
    }
    print("原始数据")
    print("-" * 20)
    json_str = json.dumps(data)
    print(json_str)
    print("-" * 20)
    json_data = json.loads(json_str)
    print(json_str)


if __name__ == '__main__':
    json_basic()

结果是：
原始数据

{“ID”: 1, “\u8bfe\u7a0b”: “python”, “\u673a\u6784”: “\u4f18\u54c1”}

{“ID”: 1, “\u8bfe\u7a0b”: “python”, “\u673a\u6784”: “\u4f18\u54c1”}

json写入

def json_writer_file():
    data = {
        "ID": 1,
        "课程": "python",
        "机构": "优品"
    }
    with open("data.json", "w", encoding="utf8") as f:
        json.dump(data,f)

if __name__ == '__main__':
    json_writer_file()
    

json读取

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


if __name__ == '__main__':
    json_read_file()
    

结果是：
{‘ID’: 1, ‘课程’: ‘python’, ‘机构’: ‘优品’}

excel文件读取

import xlrd

def xl_read():
    book = xlrd.open_workbook("test_1234.xlsx")
    for sheet in book.sheets():
        print(sheet.name)

if __name__ == '__main__':
    xl_read()

结果是：
损益表1
损益表2
损益表3

import xlrd

def xl_read():
    book = xlrd.open_workbook("test_1234.xlsx")
    for sheet in book.sheets():
        print(sheet.name)

def xl_read_data():
    book = xlrd.open_workbook("test_1234.xlsx")
    sheet = book.sheet_by_name("损益表1")
    print("工作簿：{}".format(sheet.name))
    print("数据行数：{}".format(sheet.nrows))
    print("集团损益表")
    print("=" * 50)
    for i in range(sheet.nrows):
        print(sheet.row_values(i))


if __name__ == '__main__':
    xl_read_data()

结果是：
工作簿：损益表1
数据行数：8
集团损益表

[’’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’]
[‘项目’, 43466.0, 43497.0, 43525.0, 43556.0, 43586.0, 43617.0, 43647.0, 43678.0, 43709.0, 43739.0, 43770.0, 43800.0]
[‘营业收入’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’]
[‘营业成本’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’]
[‘固定费用’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’]
[‘变动费用’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’]
[‘所得税’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’]
[‘利润’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’]