使用Python遍历excel每一行并对指定列进行修改

摸鱼仙人~

已于 2024-03-19 19:44:47 修改

阅读量765

点赞数 11

文章标签： python windows 开发语言

于 2024-01-22 12:38:47 首次发布

本文链接：https://blog.csdn.net/qq_52964132/article/details/135745335

版权

内容概述：通过pandas读取多个Excel文件，利用自定义函数处理数据，将不同来源的数据整合到result.xlsx。

摘要由CSDN通过智能技术生成

import pandas as pd

data = pd.read_excel("data.xlsx", engine="openpyxl")
result = data.copy()
f = pd.read_excel("feeding.xlsx")
m = pd.read_excel("motility.xlsx")
t = pd.read_excel("tiering.xlsx")

length_num = data.shape[0]


def search(ex:pd.DataFrame, content:str) -> None:
    pbdb = list(zip(list(ex['pbdb']),list(ex['change'])))
    for row in pbdb:
        if content == str(row[0]):
            return str(row[1])
            break
        else:
            continue


for i in range(length_num):
    df = data.iloc[i]
    new = df.copy()
    new['Motility'] = search(m, df['motility_'])
    new['Feeding'] = search(f, df['diet'])
    new['Tiering'] = search(t, df['life_habit'])
    result.iloc[i] = new

result.to_excel("result.xlsx")