pd.read_excel()练习

最新推荐文章于 2024-08-16 15:21:00 发布

jp_zhou256

最新推荐文章于 2024-08-16 15:21:00 发布

阅读量2.9k

点赞数 1

分类专栏： Python

本文链接：https://blog.csdn.net/jp_zhou256/article/details/90676921

版权

本文详细探讨了Python pandas库中的pd.read_excel()函数，用于读取Excel文件到DataFrame。通过实例展示了如何加载数据，处理不同工作表，指定索引列，以及设置数据类型等关键操作。

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

# -*- coding: utf-8 -*-
import pandas as pd
import numpy as np

df11=pd.read_excel("C:/Users/Administrator/Desktop/20190527/表1.xlsx")
df12=pd.read_excel("C:/Users/Administrator/Desktop/20190527/表2.xlsx")
df13=pd.read_excel("C:/Users/Administrator/Desktop/20190527/表3.xlsx")
df11['LipidIon.1']=df11['LipidIon.1'].apply(lambda x : x.strip())
df12['LipidIon.1']=df12['LipidIon.1'].apply(lambda x : x.strip())
df13['LipidIon.1']=df13['LipidIon.1'].apply(lambda x : x.strip())
df11['LipidIon']=df11['LipidIon'].apply(lambda x : x.strip())
df12['LipidIon']=df12['LipidIon'].apply(lambda x : x.strip())
df13['LipidIon']=df13['LipidIon'].apply(lambda x : x.strip())

df11['category']=df11['LipidIon'].apply(lambda x : x.split("+")[-1])
df12['category']=df12['LipidIon'].apply(lambda x : x.