车辆--车主关联信息画像数据集

1.数据采集：从车库系统提取“车牌号、车主姓名、车牌类型、车型”关联信息，同步获取对应车辆全量“进出时间、进出地点”记录，涵盖不同时段、出入口的通行数据；
2.数据处理：1）以“车牌号”为唯一聚合主键建关联索引；2）用“主键分组+字段合并”算法，聚合同一车牌号的车主信息、车型属性及所有历史进出记录，形成“一车一档”；3）计算车辆周/月进出次数时，以“自然周（周一至周日）”“自然月”为时间维度，通过“COUNT(进出时间)”函数统计时段内的通行记录总数，生成使用频率标签；4）对进出地点用“分组计数+降序排序”取TOP3为高频通行点标签，次数相同时按最新记录时间排序；5）以“车牌号+车主姓名”生成唯一标识，构建“车主-常用车辆”关联表，确保车主与车辆归属唯一；
3.数据应用：管理车主与名下车辆对应关系，为车主服务触达提供数据支撑，同时作为车主行为分析的前置数据集合。

1. Data Collection: Extract the associated information including "license plate number, vehicle owner name, license plate type, vehicle model" from the garage system, and synchronously obtain the complete records of "entry and exit timestamps, entry and exit locations" for the corresponding vehicles, covering passage data across different time periods and access points;
2. Data Processing: 1) Establish an associated index with "license plate number" as the unique aggregation primary key; 2) Use the algorithm of "primary key grouping + field merging" to aggregate the owner information, vehicle model attributes and all historical entry and exit records of the same license plate number to form an "one-vehicle-one-file" dossier; 3) When calculating the weekly and monthly entry and exit frequencies of vehicles, take "natural week (Monday to Sunday)" and "natural month" as time dimensions, and use the "COUNT(entry and exit timestamps)" function to count the total number of passage records within the corresponding time period, generating usage frequency tags; 4) For entry and exit locations, use "group counting + descending sorting" to select the top 3 as high-frequency access point tags, and sort by the latest record timestamp when the counts are equal; 5) Generate a unique identifier with "license plate number + vehicle owner name" to construct an "owner - commonly used vehicles" association table, ensuring the unique ownership relationship between vehicle owners and their affiliated vehicles;
3. Data Application: Manage the corresponding relationship between vehicle owners and their under-name vehicles, provide data support for the outreach of vehicle owner services, and serve as a preparatory dataset for vehicle owner behavior analysis.

搜集汇总

背景与挑战

背景概述

该数据集是一个车辆与车主关联信息画像集合，由企业自行产生，规模为4.13MB，每日更新。它适用于车库管理场景，如车辆权限核对、专属服务触达和通行偏好响应，通过算法处理车牌号、车主姓名和进出记录等数据，生成使用频率和高频通行点标签，以支持车主行为分析和精准服务。数据集特点在于聚焦商务服务业应用，以“一车一档”形式整合信息，为日常业务办理提供数据支撑。