中文字幕理论片,69视频免费在线观看,亚洲成人app,国产1级毛片,刘涛最大尺度戏视频,欧美亚洲美女视频,2021韩国美女仙女屋vip视频

pip3 install pandas
pip3 install xlrd
pip3 install openpyxl

import  pandas  as pd
from pandas import DataFrame

#創(chuàng)建DataFrame可以用下面字典，也可以用數(shù)組ndarray
dic1 = {'標(biāo)題列1': ['張三','李四'],
        '標(biāo)題列2': [80, 90]
       }
df = pd.DataFrame(dic1)
df.to_excel('1.xlsx', index=False)

pd.read_excel(io, sheet_name=0, header=0, names=None, index_col=None, 
              usecols=None, squeeze=False,dtype=None, engine=None, 
              converters=None, true_values=None, false_values=None, 
              skiprows=None, nrows=None, na_values=None, parse_dates=False, 
              date_parser=None, thousands=None, comment=None, skipfooter=0, 
              convert_float=True, **kwds)

import  pandas  as pd
from pandas import DataFrame

#讀
data = pd.read_excel('1.xlsx')

#查看所有的值
print(data.values)

#查看第一行的值
print(data.values[0])

#查看某一列所有的值
print(data['標(biāo)題列1'].values)

#新增列
data['標(biāo)題列3'] = None

#新增行
data.loc[3] = ['王五', 100, '男']

#刪除行：axis=0
data = data.drop([0,1], axis=0)

#刪除列：axis=1
data.drop('標(biāo)題列3', axis=1)

#保存
DataFrame(data).to_excel('1.xlsx', sheet_name='Sheet1', index=False, header=True)

import os
import  pandas  as pd
from pandas import DataFrame

def xlsToXlsx(srcPath, destPath):
    """srcPath路徑的所有.xls文件，用.xlsx格式保存于destPath路徑"""
    for filename in os.listdir(srcPath):
        filePath = os.path.join(srcPath,filename)
        if not filename.endswith(".xls"):
            continue        
        xlsxPath =  destPath + '\\' + filename + 'x'        
        data = pd.DataFrame(pd.read_excel(filePath))
        data.to_excel(xlsxPath, index=False)

srcPath = r'D:\python\xls'
destPath = r'D:\python\xlsx'
xlsToXlsx(srcPath, destPath)

import os
import  pandas  as pd
from pandas import DataFrame
import numpy as np

def excelMerge(srcPath, destPath):
    """同種格式的Excel文件合并"""
    fileList = [] #所有Excel文件列表
    for filename in os.listdir(srcPath):
        filePath = os.path.join(srcPath,filename)
        if not filename.endswith(".xlsx"):
            continue
        fileList.append(filePath)

    resultData = pd.read_excel(fileList[0]) #第一個Excel文件數(shù)據(jù)
    colName = resultData.columns.values #Excel文件標(biāo)題

    fileList.pop(0) #列表中刪除第一個文件

    for filepath in fileList:
        fileData = pd.read_excel(filePath)
        resultData = np.concatenate((resultData, fileData), axis=0) #合并Excel數(shù)據(jù)

    df = pd.DataFrame(resultData, columns = colName)
    df.to_excel(destPath, index=False) #保存


srcPath = r'D:\python\xlsx'
destPath = r'D:\python\list.xlsx'
excelMerge(srcPath, destPath)

本站僅提供存儲服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點擊舉報。