Student Alcohol Consumption学生酒类消费

import pandas as pd
import numpy as np
df = pd.read_csv(“datas/student-mat.csv”)
df.head()

stud_alcoh = df.loc[:, “school”:“guardian”]
stud_alcoh.head()

captalizer = lambda x : x.upper()

stud_alcoh[“Mjob”].apply(captalizer)
stud_alcoh[“Fjob”].apply(captalizer)

stud_alcoh.tail()

stud_alcoh[“Mjob”] = stud_alcoh[“Mjob”].apply(captalizer)
stud_alcoh[“Fjob”] = stud_alcoh[“Fjob”].apply(captalizer)
stud_alcoh.tail()

def majority(x):
if x > 17:
return True
else:
return False
stud_alcoh[“legal_drinker”] = stud_alcoh[“age”].apply(majority)
stud_alcoh.head()

def times10(x):
if type(x) is int:
return 10*x
return x
stud_alcoh.applymap(times10).head()