基于键值对填充序列

2024-04-26 18:42:06 发布

您现在位置:Python中文网/ 问答频道 /正文

我有一个包含代码和名称字典的数据框。有些名字是空白的。我试图根据代码与名称匹配的其他示例来填补这些空白。到目前为止,我已经按代码对df进行了分类,但不知道如何“填空”。这是我的密码:

import pandas as pd
import json
from pandas.io.json import json_normalize
df = pd.read_json('data/world_bank_projects.json')
theme= pd.DataFrame([val for pair in df['mjtheme_namecode'].values for val in pair])
theme1 = theme.set_index('code').sort_index()
print(theme1)

                     name
code                     
1     Economic management
1     Economic management
1     Economic management
1     Economic management
1     Economic management
1     Economic management
1     Economic management
1     Economic management
1     Economic management
1     Economic management
1                        
1     Economic management
1                        
1     Economic management
1     Economic management
1                        
1     Economic management
1     Economic management
1     Economic management
1     Economic management

在我填写之后,我想数一数(用相同的代码或名称)。我想我可以用价值计算,对吗?你知道吗


Tags: 代码inimport名称jsonpandasdffor