pandas
专职
人生苦短,我用python
展开
-
pandas中如何实现按照年、月、日筛选数据
import pandas as pd# 文件路径path = r"D:\Desktop\test\2017-2019汇总表.csv"# 读取文件df = pd.read_csv(path, dtype={"设计师ID": object, "第二销售代表ID": object, "促销活动名称": object})# 转换为日期格式df["传图时间"] = pd.to_d.原创 2020-07-22 13:24:29 · 4252 阅读 · 0 评论 -
pandas中复杂计算列的用法
import pandas as pdimport numpy as npdef get_circular_area(l, h): r = np.sqrt(l ** 2 + h ** 2) / 2 return np.pi * (r ** 2)def wrapper(row): return get_circular_area(row["Length"], row["Height"])rectangles = pd.read_excel(r"F:\101_pan.原创 2020-06-06 19:20:12 · 875 阅读 · 0 评论 -
pandas中dataframe中列的操作方法和空行的操作方法
import pandas as pdimport numpy as npimport randomstudent01 = pd.read_excel(r"F:\101_pandas视频教程\pandas_excel\Students.xlsx", sheet_name="Page_001")student02 = pd.read_excel(r"F:\101_pandas视频教程\pandas_excel\Students.xlsx", sheet_name="Page_002")# 将两.原创 2020-06-06 16:54:27 · 2861 阅读 · 0 评论 -
pandas中dataframe中行的各种操作
import pandas as pdimport numpy as npstudents01 = pd.read_excel(r"F:\101_pandas视频教程\pandas_excel\Students.xlsx", sheet_name="Page_001")students02 = pd.read_excel(r"F:\101_pandas视频教程\pandas_excel\Students.xlsx", sheet_name="Page_002")# 合并两个DataFrame成.原创 2020-06-06 15:46:02 · 279 阅读 · 0 评论 -
pandas中通过日期获取年月日季度和透视聚合pivot_table分组聚合groupby的用法
import pandas as pdimport numpy as np# pd.options.display.max_columns = 999 # 允许print输出的最大列数orders_df = pd.read_excel(r"F:\101_pandas视频教程\pandas_excel\Orders.xlsx")# 获取年orders_df["year"] = pd.DatetimeIndex(orders_df["Date"]).year# 获取月orders_df[".原创 2020-06-06 11:51:43 · 2398 阅读 · 0 评论 -
pandas中读取txt和tsv以及将一列拆分成多列的用法
import pandas as pdpath = r"F:\101_pandas视频教程\pandas_excel"s1 = pd.read_csv(path + "\\" + "Students.csv", index_col="ID")# pandas中读取txt和tsv格式s2 = pd.read_csv(path + "\\" + "Students.tsv", sep="\t", index_col="ID")s3 = pd.read_csv(path + "\\" + "Stu.原创 2020-06-06 10:03:17 · 2647 阅读 · 0 评论 -
python中的pandas用法大全
import numpy as npimport pandas as pd# 一:生成数据表# 1. 用pandas创建数据表# df3 = pd.DataFrame({"id": [1001, 1002, 1003, 1004, 1005, 1006],# "date": pd.date_range("20200425", periods=...原创 2020-04-25 16:33:29 · 526 阅读 · 0 评论 -
pandas中的排序和筛选
# 1. 排序df2 = df.sort_values(by=["Worthy", "Price"], ascending=[True, False])# 2. 筛选def level_a(s): """筛选分数大于等于85并且小于等于100的学生""" return 85 <= s <= 100df_students = df_students.loc[...原创 2020-05-07 19:52:56 · 293 阅读 · 0 评论