用pandas对csv表中‘HPHM’的值相同的行进行操作,进行的操作是用‘KKBH’的值为‘500011015000’的行的‘GCSJ’的值减去‘KKBH’的值为‘500011012000’的行的‘GCSJ’的值,并将所得结果导出,表中‘KKBH’的值均表示为‘5E+11’。
时间: 2023-09-25 19:09:19 浏览: 35
可以按照以下步骤进行操作:
1. 读取csv文件并存储为一个pandas的DataFrame对象,假设文件名为data.csv。
```python
import pandas as pd
df = pd.read_csv('data.csv')
```
2. 筛选出‘KKBH’的值为‘500011015000’和‘500011012000’的行,并且‘HPHM’的值相同。
```python
mask = (df['KKBH'] == '5E 11') & (df['HPHM'].duplicated(keep=False))
df_filtered = df[mask].sort_values(by=['HPHM', 'KKBH'])
```
3. 将‘GCSJ’的值为‘500011015000’的行的‘GCSJ’的值减去‘500011012000’的行的‘GCSJ’的值,并将所得结果添加到一个新的列‘RESULT’中。
```python
df_filtered['RESULT'] = df_filtered.loc[df_filtered['KKBH'] == '500011015000', 'GCSJ'].values - df_filtered.loc[df_filtered['KKBH'] == '500011012000', 'GCSJ'].values
```
4. 将结果导出为一个新的csv文件,假设文件名为result.csv。
```python
df_filtered.to_csv('result.csv', index=False)
```
完整代码如下所示:
```python
import pandas as pd
df = pd.read_csv('data.csv')
mask = (df['KKBH'] == '5E 11') & (df['HPHM'].duplicated(keep=False))
df_filtered = df[mask].sort_values(by=['HPHM', 'KKBH'])
df_filtered['RESULT'] = df_filtered.loc[df_filtered['KKBH'] == '500011015000', 'GCSJ'].values - df_filtered.loc[df_filtered['KKBH'] == '500011012000', 'GCSJ'].values
df_filtered.to_csv('result.csv', index=False)
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)