Python的Excel文件操作

# print("hello world!")
# print("hello world!")
# print("hello")
# money=50
# print("钱包余额：",money)
# money=money-10
# print("钱包余额：",money,"元")

# 每个一小时输出余额
# print(type(6.14))
# n="haih"
# print(type(n))
# x=type("hahs")
# print(x)

# n=str(11)
# print(type(n),n)
# m=int("11")
# print(type(m),m)
# m1=float(11)
# print(m1)
# m3=int(11.564)
# print(m3)
# print(9%2)
# n=1
# m=2
# n+=m
# print(n)
# n=1+2*3
# print(n)

# n='nhaos'
# n1="jfsanfj"
# print(type(n),type(n1))
# print("\"dsfjs\"")
# bool_1=True
# False
# print(bool_1,type(bool_1))
# print(f"sgds{bool_1}")

# age=int(input("请输入年龄："))
# if int(input("请输入年龄："))>18:
#     print("naho")
# elif int(input("请输入年龄："))>16:
#     print("1")
# else:
#     print("sha")

# n="hello"
# for i in n:
#     print(i)

# n="isjdjfs sdfs fssad1"
# x=0
# for i in n:
#     if(i=="1"):
#         x+=1
# print(x)

# for i in range(10):
#     print(i)

# for i in range(5,10,2):
#     print(i)
# i=0
# for i in range(5):
#     print(i)
#
# print(i)

# i=0
# for i in range(1,101):
#     print(f"第{i}天")
#
#     for j in range(1,11):
#         print(f"第{j}朵")
#     print("表白")
# print(i)

# import time
# f=open("F:/1/test.txt","r",encoding="UTF-8")
# print(type(f))
# print(f"读取:{f.read(20)}")
# print(f"neirong:{f.readlines()}")
# print(f.readline())
# line=f.readline()

# for line in f:
#     print(f"第行{line}")

# f.close()
# time.sleep(50000)

# with open("F:/1/test.txt","r",encoding="UTF-8") as f:
#     for line in f:
#        print(f"第行{line}")
#
# time.sleep(50000)

# from pyecharts.charts import Line
# line=Line()
# line.add_xaxis(["中国","美国","英国"])
# line.add_yaxis("GDP",[30,20,10])
# line.render()

# import xlrd
# data=xlrd.open_workbook('data.xlsx')
# table=data.sheets()[0]
# print(table)

# import pandas as pd
# path=r'F:/1/data.xlsx'
# frame=pd.read_excel(path)
# frame

# import pandas as pd
# path = r'F:\1\data.xlsx'
# frame = pd.read_excel(path)   # 直接使用 read_excel() 方法读取
# print(frame)

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import matplotlib
import xlwt


path = r'F:\1\data.xlsx'
frame = pd.read_excel(path)   # 直接使用 read_excel() 方法读取
data = np.array(frame)    #转成二维数组
print(data)               #输出整个数组
# print(data[1])            #输出第二行数
# print(data[:,0])          #输出第一列数
# print(data[1,3])            #输出第二行第四列的数
# print(data[1:3,5])            #输出第六列的第二和第三个数

# book = xlwt.Workbook(encoding='utf-8',style_compression=0)
# sheet = book.add_sheet('豆瓣电影Top250',cell_overwrite_ok=True)
# col = ('电影详情链接','图片链接','影片中文名','影片外国名','评分','评价数','概况','相关信息')
# for i in range(0,8):
# 		sheet.write(0,i,col[i])
# datalist = [['www','www图片','西游记','xiyouji','100分','0人','很好','超级棒'],['www2','www图片2','西游记2','xiyouji2','1000分','1人','很棒','一级棒']]
# for i in range(0,2):
# 		data = datalist[i]
# 		for j in range(0,8):
# 			sheet.write(i+1,j,data[j])
# for i in range(0,6):
# 		sheet.write(0,i,data[0,i])


# print(data[0,1])
# datalist = [['www','www图片','西游记','xiyouji','100分','0人','很好','超级棒'],['www2','www图片2','西游记2','xiyouji2','1000分','1人','很棒','一级棒']]
# for i in range(0,2):
# 		# data = datalist[i]
# 		for j in range(0,6):
# 			sheet.write(i+1,j,data[i+1,j])
#
# savepath = 'F:/1/excel表格.xls'
# book.save(savepath)


# plt.figure(figsize=(6,8))  #图框大小
# plt.ylim(0,120) #坐标范围
# plt.xlim(0,120)
# plt.plot(data[:,1],data[:,5])  #横坐标和纵坐标的数据
# plt.show()