2023年巽风集市消费用户的年龄及城市分布

数据采集规则：1、巽风集市用户商品成交时采集相关信息包括用户ID，成交时间。2、巽风数字世界用户注册账号时采集相关信息包括用户ID，用户性别、注册IP、出生日期等。
数据取数逻辑：1、在用户商品成交信息中筛选有付费行为的用户ID。2、在用户商品成交信息中通过cjemgkoap时间获取成交年份。在用户账号注册信息中通过解析注册IP获取用户注册的省份。在用户账号注册信息中通过生日数据获取年龄信息并区分年龄段。对清洗后的的数据通过用户ID关联，并按照成交年份、注册省份、注册性别、年龄分段进行聚合统计。

Data Collection Rules:
1. Relevant information including user ID and transaction time is collected when users complete commodity transactions on the Xunfeng Market.
2. Relevant information including user ID, user gender, registration IP, date of birth and others is collected when users register accounts in the Xunfeng Digital World.

Data Extraction and Processing Logic:
1. Filter out user IDs with paid transaction behaviors from the user commodity transaction information.
2. Obtain the transaction year from the cjemgkoap timestamp in the user commodity transaction information; obtain the user's registered province by parsing the registration IP from the user account registration information; derive age information and categorize age groups based on the date of birth data from the user account registration information. Associate the cleaned data via user ID, and perform aggregate statistics according to transaction year, registered province, registered gender and age segments.

搜集汇总

背景与挑战

背景概述

该数据集包含2023年巽风集市消费用户的年龄及城市分布信息，共32条数据，用于分析茅台酒及其周边产品的用户分布情况，数据结构涵盖省份、用户总数、性别及各年龄段用户数等关键字段。