练习1 读取餐饮csv文件的数据
- 方法1
import csv
with open("餐饮.csv","r") as f:
data = csv.reader(f)
for i in data:
print(i)
结果:
- 方法2
import pandas as pd
data = pd.read_csv("餐饮.csv",encoding = "gb18030")
data
练习2 读取Stock.xlsx 文件数据
- 方法1
from openpyxl import load_workbook
wb = load_workbook("Stock.xlsx")
ws = wb.active
for row in ws.rows:
for cell in row:
print(cell.value)
结果:
- 方法2
data = pd.read_excel("Stock.xlsx")
data
结果:
练习3:
• 1.输出0-9的数组arr
• 2.查看arr的数据类型
• 3.创建0-5的数组arr1,并指定其数据类型为"bool"
• 4.改变arr1的数据类型为"float64"
import numpy as np
arr = np.arange(0,10)
print(arr)
print(arr.dtype)
arr1 = np.array(range(0,6),dtype = "?")
print(arr1)
arr1 = arr1.astype("float64")
print(arr1)
结果: