【功能一】
两个excel,需要找到姓名相同的输出历史体重和当前体重,想要的结果为:
import tkinter as tk
from tkinter import filedialog
import pandas as pd
实例化
root = tk.Tk()
root.withdraw()
获取文件夹路径
f_path = filedialog.askopenfilename()
print(‘\n获取的文件地址:’, f_path)
读取选择文件
df = pd.DataFrame(pd.read_excel(f_path))
获取文件夹路径
f_path1 = filedialog.askopenfilename()
print(‘\n获取的文件地址:’, f_path1)
读取选择文件
df1 = pd.DataFrame(pd.read_excel(f_path1))
for i in df.index:
flag = 0
for j in df1.index:
if df.at[i,’姓名’] == df1.at[j,’姓名’]:
print(df.at[i,’姓名’],df.at[i,’体重’],df1.at[j,’体重’])
flag = 1
if flag == 0:
print(df.at[i,’姓名’],df.at[i,’体重’],None)
for i in df1.index:
flag = 0
for j in df.index:
if df1.at[i,’姓名’] == df.at[j,’姓名’]:
flag = 1
if flag == 0:
print(df1.at[i,’姓名’],None,df1.at[i,’体重’])
Original: https://blog.csdn.net/ql6409/article/details/124621100
Author: JX6409
Title: 【Python Pandas】处理Excel实践
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/742508/
转载文章受原作者版权保护。转载请注明原作者出处!