浙江省玉环市燃气用户天然气用气分析数据

统计分析时间范围内燃气公司用户用气量、用气金额、当前阶梯单价，账户余额变更记录、期间充值金额、期间补气金额、期间退气金额、差值金额等。用于跟踪检测用户用气情况，可避免出现用气金额不平的现象,维护燃气用户合法权益。针对用气金额，燃气公司也可以清楚的了解用户习惯，有助于预测未来的用气需求，为天然气供应和运营提供依据。1.数据采集：采集抄表员针对用户上门进行抄表，通过设备上传用户表具读数。
2.数据处理：对采集到的数据进行清洗，排除抄表度数为0的或者为null的数据后按用户进行分类，作为最基本数据。
3.数据分析：对处理后的数据按用户进行分类，按算法公式进行统计，户名、户号、表号、客户地址、电话为业务系统实际用户信息，单价为用户年度累计用气量对应价格阶梯单价，用气量=本次抄表读数-上次抄表读数，用气金额=用气量*单价（用户当前所处阶梯价格）。期间充值金额为统计时间范围内，用户的充值记录金额总和。期间补气金额为统计范围内用户补气金额总和。期间退气金额为统计范围内用户退气金额总和，差额金额=上次账户余额-本次账户余额+充值量-用气金额+补气金额-扣气金额。

This dataset conducts statistical analysis on metrics including user gas usage volume, gas usage amount, current tiered unit price, account balance change records, total recharge amount during the period, total gas top-up amount during the period, total gas refund amount during the period, and difference amount within a specified statistical time range. It is used to track and detect user gas usage conditions, prevent unbalanced gas usage amounts, and safeguard the legitimate rights and interests of gas users. Regarding gas usage amounts, gas companies can gain clear insights into user usage habits, which helps forecast future gas demand and provide a basis for natural gas supply and operations.
1. Data Collection: Collect on-site meter reading data from users performed by meter readers, and upload the readings of user gas meters via related devices.
2. Data Processing: Clean the collected data, exclude entries with meter reading values of 0 or null, then classify the remaining data by user as the basic dataset.
3. Data Analysis: Classify the processed data by user and perform statistics according to algorithmic formulas. The user name, user ID, meter number, customer address and contact phone number are the actual user information from the business system. The unit price refers to the tiered unit price corresponding to the user's annual cumulative gas usage. The specific calculation formulas are as follows:
Gas Usage = Current Meter Reading - Previous Meter Reading
Gas Usage Amount = Gas Usage * Unit Price (the tiered price matching the user's current usage tier)
Total Recharge Amount during the Statistical Period: The sum of all user recharge record amounts within the statistical time range.
Total Top-up Amount during the Statistical Period: The sum of all user gas top-up amounts within the statistical time range.
Total Gas Refund Amount during the Statistical Period: The sum of all user gas refund amounts within the statistical time range.
Difference Amount = Previous Account Balance - Current Account Balance + Total Recharge Amount - Gas Usage Amount + Total Top-up Amount - Deducted Gas Amount

搜集汇总

数据集介绍

特点

该数据集包含浙江省玉环市燃气用户的天然气用气分析数据，涵盖用户基本信息、用气量、用气金额等16个字段，共2329条记录，每日更新。适用于统计分析用户用气情况和预测未来需求。