摘要: import os import pandas as pd # 修改工作路径到指定文件夹 os.chdir("E:/桌面/data") # 第一种连接方式 from sqlalchemy import create_engine engine = create_engine('mysql+pymys 阅读全文
posted @ 2023-04-02 20:56 沁悬 阅读(68) 评论(0) 推荐(0)
摘要: import pandas as pd import matplotlib.pyplot as plt import numpy as np inputfile ='E:\桌面\data\original_data.xls' #'./demo/data/original_data.xls' # 输入 阅读全文
posted @ 2023-03-26 20:21 沁悬 阅读(65) 评论(0) 推荐(0)
摘要: import numpy as np import pandas as pd import matplotlib.pyplot as plt inputfile='E:/桌面/data/GoodsOrder.csv' data=pd.read_csv(inputfile,encoding='gbk' 阅读全文
posted @ 2023-03-19 22:21 沁悬 阅读(33) 评论(0) 推荐(0)
摘要: import pandas as pd import numpy as np import matplotlib.pyplot as plt import seaborn as sns plt.rcParams['font.sans-serif'] = ['SimHei'] # 用来正常显示中文标签 阅读全文
posted @ 2023-03-12 22:14 沁悬 阅读(75) 评论(0) 推荐(0)
摘要: import numpy as np import pandas as pdfrom sklearn.linear_model import Lasso inputfile ='E:/桌面/data.csv' data = pd.read_csv(inputfile,engine='python') 阅读全文
posted @ 2023-03-05 21:40 沁悬 阅读(95) 评论(0) 推荐(0)
摘要: import numpy as np import pandas as pd df = pd.read_excel('E:\桌面\catering_sale.xls') df.fillna(0) #print(df.isnull()) #print(df['销量'].sum()) import ma 阅读全文
posted @ 2023-02-26 20:15 沁悬 阅读(71) 评论(0) 推荐(0)
摘要: import mathimport numpy as npimport pandas as pdfrom pandas import DataFrame,Seriesdef sigmoid(x): return 1/(1+math.exp(-x))x1=[0.29,0.50,0.00,0.21,0. 阅读全文
posted @ 2022-03-19 20:53 沁悬 阅读(48) 评论(0) 推荐(0)