Python 官方文档:入门教程 => 点击学习
import pandas as pd 创建 DataFrame 从列表创建: df = pd.DataFrame({"name": ["Alice", "Bob", "Carol"], "age": [20, 25, 30]})
import pandas as pd
创建 DataFrame
df = pd.DataFrame({"name": ["Alice", "Bob", "Carol"], "age": [20, 25, 30]})
df = pd.DataFrame({
"name": ["Alice", "Bob", "Carol"],
"age": [20, 25, 30],
"city": ["London", "Paris", "Rome"]
})
df = pd.read_csv("data.csv")
访问数据
df["age"]
df.loc[0]
df.loc[0, "age"]
操纵数据
df["city"] = ["London", "Paris", "Rome"]
df.drop("age", axis=1, inplace=True)
filtered_df = df[df["age"] > 25]
sorted_df = df.sort_values("age")
grouped_df = df.groupby("city")
合并数据
df1 = pd.DataFrame({"name": ["Alice", "Bob"], "age": [20, 25]})
df2 = pd.DataFrame({"name": ["Bob", "Carol"], "city": ["Paris", "Rome"]})
merged_df = pd.merge(df1, df2, on="name")
df1 = pd.DataFrame({"name": ["Alice", "Bob"], "age": [20, 25]})
df2 = pd.DataFrame({"city": ["London", "Paris"], "index": [0, 1]})
merged_df = pd.merge(df1, df2, left_index=True, right_index=True)
数据处理
df["age"].sum()
df["age"].mean()
df["age"].std()
df["city"].mode()
输出数据
df.to_csv("data.csv")
df.to_excel("data.xlsx")
df.to_html("data.html")
--结束END--
本文标题: Python Pandas 入门秘笈,让数据处理轻松上手!
本文链接: https://www.lsjlt.com/news/583065.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0