Thanksgiving Day

感恩节调查数据分析

最新推荐文章于 2020-12-29 12:12:44 发布

原创最新推荐文章于 2020-12-29 12:12:44 发布 · 310 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据

python练手专栏收录该内容

4 篇文章

订阅专栏

本博客通过使用Python的pandas库对感恩节庆祝活动进行详细的数据分析。内容包括庆祝情况、主菜选择、是否使用肉汁、派的选择以及参与者年龄与收入的分布等。通过数据透视表进一步探究不同人群的庆祝习惯。

数据来源：链接

# coding: utf-8
import pandas as pd
data = pd.read_csv("thanksgiving.csv",encoding="Latin-1")
data.head(1)
data.columns
DYCT = data["Do you celebrate Thanksgiving?"].value_counts()

Filter_DYCT = data[data["Do you celebrate Thanksgiving?"]=="Yes"]

MDTD = data["What is typically the main dish at your Thanksgiving dinner?"].value_counts()

is_Tofurkey = data["What is typically the main dish at your Thanksgiving dinner?"]=="Tofurkey"
gravy = data["Do you typically have gravy?"][is_Tofurkey]

apple_isnull = pd.isnull(data["Which type of pie is typically served at your Thanksgiving dinner? Please select all that apply. - Apple"])
Pumpkin_isnull = pd.isnull(data["Which type of pie is typically served at your Thanksgiving dinner? Please select all that apply. - Pumpkin"])
Pecan_isnull = pd.isnull(data["Which type of pie is typically served at your Thanksgiving dinner? Please select all that apply. - Pecan"])

ate_pies = apple_isnull & Pumpkin_isnull & Pecan_isnull
data[ate_pies]
ate_pies.value_counts()
def convert_age(x):
    if pd.isnull(x):
        return None
    x = int(x.split(" ")[0].replace("+",""))
    return x

data["int_age"] = data["Age"].apply(convert_age)
data["int_age"].describe()

def convert_income(x):
    if pd.isnull(x):
        return None
    x = x.split(" ")[0]
    if x=="Prefer":
        return None
    else:
        x=x.replace("$","").replace(",","")
    return int(x)

int_income = data["How much total combined money did all members of your HOUSEHOLD earn last year?"].apply(convert_income)
int_income.value_counts().sort_index()
int_income.describe()
data[int_income < 150000]
data["How far will you travel for Thanksgiving?"][int_income >150000].value_counts()
# 在两者数据中显示，不管收入如何，感恩节不回去旅游的人是占最多的

data.pivot_table(index="Have you ever tried to meet up with hometown friends on Thanksgiving night?",columns='Have you ever attended a "Friendsgiving?"',values="int_age")
# 从两组数据看出，参加朋友聚会的人群呈年轻化