用 Pandas 深度剖析数据：从读取到统计分析全流程实战

1. ```python import pandas as pd data = pd.read_csv('data.csv') print(data.head(5)) ``` 2. ```python print(data.dtypes) # 查看数据类型 print(data.isnull().sum()) # 查看缺失值 print(data.describe()) # 查看数据基本的数值统计详细信息 ``` 3. ```python data['date'] = pd.to_datetime(data['date']) # 对日期格式数据做日期转换 ``` 4. ```python # (1) city_job_count = data['city'].value_counts() print(city_job_count.head(5)) # (2) education_filtered = data[(data['education'] == '本科') | (data['education'] == '大专')] # (3) data['district'] = data['district'].apply(lambda x: '成都-' + x if x != '其他' else x) # (4) position_advantage_count = data['positionadvantage'].str.contains('双休').sum() / len(data) * 100 print('{:.2f}%'.format(position_advantage_count)) ``` 5. ```python data['最低工资'] = data['salary'].apply(lambda x: int(x.split('-')[0][:-1])) data['最高工资'] = data['salary'].apply(lambda x: int(x.split('-')[1][:-1])) ``` ######[AI写代码神器 | 642点数解答 | 2024-06-30 15:39:49]