一、如何创建菜单栏
import socket
import threading
import tkinter as tk
import tkinter.messagebox
import tkinter.scrolledtext
import tkinter.filedialog
from tkinter import *
win=tk.Tk()
win["height"]=400
win["width"]=600
filename=""
def openfun():
global filename
filename=tk.filedialog.askopenfilename(title="openfile")
if filename!="":
fff=open(filename,"r").read()
txtCont.insert(END,fff)
pass
def savefun():
pass
def saveasfun():
pass
def closefun():
pass
def copyfun():
pass
def pastefun():
pass
def cutfun():
pass
menu1=tk.Menu(win)
submenu=tk.Menu(menu1,tearoff=0)
submenu.add_command(label="Open",command=openfun)
submenu.add_separator()
submenu.add_command(label="Save",command=openfun)
submenu.add_separator()
submenu.add_command(label="SaveAs",command=openfun)
submenu.add_separator()
submenu.add_command(label="Close",command=openfun)
submenu2=tk.Menu(menu1,tearoff=0)
submenu2.add_command(label="Copy",command=openfun)
submenu2.add_separator()
submenu2.add_command(label="Cut",command=openfun)
submenu2.add_separator()
submenu2.add_command(label="Paste",command=openfun)
menu1.add_cascade(label="File",menu=submenu)
menu1.add_cascade(label="Edit",menu=submenu2)
win.config(menu=menu1)
txtCont=tk.scrolledtext.ScrolledText(win,wrap=tk.WORD)
txtCont.pack(fill=tk.BOTH)
win.mainloop()
二、创建直方图
1.叠加bar图
import numpy as np
import matplotlib as mpl
mpl.rcParams["font.sans-serif"]=["SimHei"]
x_data=[1,2,3,4]
y_data=[150,550,100,600]
y_data2=[100,650,300,200]
import matplotlib.pyplot as plt
plt.bar(x=range(len(x_data)),height=y_data,Label="C语言基础",color="steelblue",alpha=0.6)
plt.bar(x=np.arange(len(x_data)),height=y_data2,bottom=y_data,Label="java基础",color="indianred",alpha=0.6)
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/800b68de6d15ec84957f8a1f659ec43c.png)
2.并排的bar图
import numpy as np
import matplotlib as mpl
mpl.rcParams["font.sans-serif"]=["SimHei"]
bar_width=0.3
x_data=[1,2,3,4]
y_data=[150,550,100,600]
y_data2=[100,650,300,200]
y_data3=[60,50,350,220]
import matplotlib.pyplot as plt
plt.bar(x=np.arange(len(x_data)),width=bar_width,height=y_data,Label="C语言基础",color="blue",alpha=0.6)
plt.bar(x=np.arange(len(x_data))+bar_width,width=bar_width,height=y_data2,Label="java基础",color="red",alpha=0.6)
plt.bar(x=np.arange(len(x_data))+bar_width*2,width=bar_width,height=y_data3,Label="java基础",color="green",alpha=0.6)
plt.show()
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/910c1a98b602a4cca6c330e7277815aa.png)
三、pandas读取数据的三种格式
import pandas as pd
order=pd.read_table(r"G:\大数据实验数据库\3.大数据实验数据\meal_order_info.csv",sep=",",encoding="GBK")
order=pd.read_csv(r"G:\大数据实验数据库\3.大数据实验数据\meal_order_info.csv",sep=",",header=None,encoding="GBK")
order.to_csv("c:/ab.csv",sep=",",index=False,header=False)
userlist=pd.read_excel("G:/大数据实验数据库/3.大数据实验数据/users.xlsx")
print(userlist)
四、pandas读取execel的具体操作
import pandas as pd
detail=pd.read_excel("G:/大数据实验数据库/3.大数据实验数据/meal_order_detail.xlsx",sep=",")
print(detail.ndim)
print(detail.shape)
print(detail.size)
print(detail.columns)
print(detail.dtypes)
print(detail.values)
print(detail.detail_id[0])
print(detail["detail_id"][0])
detail["detail_id"][:10]
detail["detail_id"][130:100:-1]
t=detail.columns[2]
detail[t][100:130]