import pandas
defgenerate_age_label(row):
age = row["Age"]if pandas.isnull(age):return"unknown"elif age <18:return"minor"else:return"adult"
titanic_survival = pandas.read_csv("titanic_train.csv")# 从每列返回第100项# apply 沿着DataFrame的轴应用一个函数。# axis : {0 or 'index', 1 or 'columns'}, default 0# 0 or 'index': apply function to each column. 每列# 1 or 'columns': apply function to each row. 每行
age_labels = titanic_survival.apply(generate_age_label, axis=1)
titanic_survival['age_labels666']= age_labels
age_group_survival = titanic_survival.pivot_table(index="age_labels666", values="Survived")print(age_group_survival)
import pandas
defhundredth_row(column):# 提取第100项
hundredth_item = column.iloc[99]return hundredth_item
titanic_survival = pandas.read_csv("titanic_train.csv")# 从每列返回第100项# apply 沿着DataFrame的轴应用一个函数。# axis : {0 or 'index', 1 or 'columns'}, default 0# 0 or 'index': apply function to each column. 每列# 1 or 'columns': apply function to each row. 每行
hundredth_data = titanic_survival.apply(hundredth_row)print(hundredth_data)
import pandas
defnot_null_count(column):
column_null = pandas.isnull(column)
null = column[column_null]returnlen(null)
titanic_survival = pandas.read_csv("titanic_train.csv")# 从每列返回第100项# apply 沿着DataFrame的轴应用一个函数。# axis : {0 or 'index', 1 or 'columns'}, default 0# 0 or 'index': apply function to each column. 每列# 1 or 'columns': apply function to each row. 每行
column_null_count = titanic_survival.apply(not_null_count)print(column_null_count)
import pandas
defwhich_class(row):
pclass = row['Pclass']if pandas.isnull(pclass):return"Unknown"elif pclass ==1:return"First Class"elif pclass ==2:return"Second Class"elif pclass ==3:return"Third Class"
titanic_survival = pandas.read_csv("titanic_train.csv")# 从每列返回第100项# apply 沿着DataFrame的轴应用一个函数。# axis : {0 or 'index', 1 or 'columns'}, default 0# 0 or 'index': apply function to each column. 每列# 1 or 'columns': apply function to each row. 每行
classes = titanic_survival.apply(which_class, axis=1)print(classes)
import pandas
defis_minor(row):if row["Age"]<18:returnTrueelse:returnFalse
titanic_survival = pandas.read_csv("titanic_train.csv")# 从每列返回第100项# apply 沿着DataFrame的轴应用一个函数。# axis : {0 or 'index', 1 or 'columns'}, default 0# 0 or 'index': apply function to each column. 每列# 1 or 'columns': apply function to each row. 每行
minors = titanic_survival.apply(is_minor, axis=1)print(minors)
import pandas
defgenerate_age_label(row):
age = row["Age"]if pandas.isnull(age):return"unknown"elif age <18:return"minor"else:return"adult"
titanic_survival = pandas.read_csv("titanic_train.csv")# 从每列返回第100项# apply 沿着DataFrame的轴应用一个函数。# axis : {0 or 'index', 1 or 'columns'}, default 0# 0 or 'index': apply function to each column. 每列# 1 or 'columns': apply function to each row. 每行
age_labels = titanic_survival.apply(generate_age_label, axis=1)print(age_labels)