- 练习一
题目: 餐饮.csv
读取餐饮csv文件的数据
import csv
with open("餐饮.csv") as csv_one:
datawriter = csv.reader(csv_one)
new_list = []
for i in datawriter:
new_list.append(i)
print(new_list)
- 练习二
题目:Stock.xlsx
读取Stock.xlsx 文件数据
import openpyxl
wb = openpyxl.load_workbook("Stock.xlsx",data_only=True,read_only=True)
ws = wb.active
for j in ws.rows:
for i in j:
print(i.value)
- 练习三(numpy基础练习)
题目:
1.输出0-9的数组arr
2.查看arr的数据类型
3.创建0-5的数组arr1,并指定其数据类型为"bool"
4.改变arr1的数据类型为"float64"
import numpy as np
arr = np.arange(9)
print(arr)
print(arr.dtype)
arr1 = np.array(range(5),dtype="?")
arr1 = arr1.astype("?")