![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
python之pandas库
pandas使用
小蜗笔记
热爱建模和计算机
展开
-
pandas多次写入不同的sheet
截取官方文档原创 2022-07-14 10:04:21 · 582 阅读 · 0 评论 -
破解excel格式保护
#筛选用import pandas as pdimport numpy as npimport re#pd.options.display.max_columns = Nonepd.set_option('display.max_columns', None)pd.set_option('display.max_rows', None)import osname = pd.read_excel(r'D:\\个.xls',sheet_name = 0) for i in [2012]原创 2021-03-14 19:02:44 · 150 阅读 · 1 评论 -
数值计算_虚拟变量矩阵
import pandas as pdimport numpy as nppd.set_option('display.max_columns', None)pd.set_option('display.max_rows', None)dataf = pd.read_excel(r'C:\Users\Admin\Desktop\统计资料\data使用中\16个行业分类\程序用格式\\3月11程序用数据表.xlsx',sheet_name = 0)datafhangyefenlie = dat原创 2021-03-10 21:53:29 · 236 阅读 · 0 评论 -
excel批量转csv表格,解除密码另存为xlsx
参考:https://jingyan.baidu.com/article/380abd0a032e681d91192c74.htmlSub SaveToCSVs() Dim fDir As String Dim wB As Workbook Dim wS As Worksheet Dim fPath As String Dim sPath As String fPath = "C:\Users\qiany\Desktop\文件\" s原创 2021-03-04 16:30:27 · 285 阅读 · 1 评论 -
pandas数据拼接merge
import pandas as pdresult_0 = pd.read_csv('2006年污染.csv',encoding = 'GBK')result = result_0for i in range(2007,2019): result_1 = pd.read_csv('{}年污染.csv'.format(i),encoding = 'GBK') result = pd.merge(result,result_1, on= ['养殖品种','养殖方式','省份编码'], ho原创 2021-03-03 10:52:22 · 66 阅读 · 0 评论 -
pandas对excel的操作实战句法
供大家随时查阅import pandas as pdimport numpy as npimport re#pd.options.display.max_columns = Nonepd.set_option('display.max_columns', None)pd.set_option('display.max_rows', None)import ospath = 'C:\\Users\\Admin\\Documents\\vscode\\长江\\2000补充'excel_name原创 2021-03-03 10:35:00 · 212 阅读 · 1 评论 -
pandas读取文件报list index out of range
import osimport pandas as pdpath = r'C:\\Users...'excelFile = os.path.join(path,'文件名')# 报错原因应该是字符编码不匹配data = pd.read_excel(excelFile)https://blog.csdn.net/qq_26583361/article/details/102734418import pandas as pddata = pd.read_excel(path,sheet_nam原创 2021-03-01 08:34:32 · 1455 阅读 · 2 评论 -
pandas展示数据全部的行与列
import pandas as pd#pd.options.display.max_columns = None # 也ok,亲测pd.set_option('display.max_columns', None)pd.set_option('display.max_rows', None)原创 2021-02-28 08:39:20 · 712 阅读 · 0 评论