回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个数据框,看起来像这样:</p>
<p><a href="https://i.stack.imgur.com/55UUP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/55UUP.png" alt="enter image description here"/></a></p>
<p>创建df的代码:</p>
<pre><code>dd = {'name': ["HARDIE'S MOBILE HOME PARK", 'CRESTVIEW RV PARK',
'HOMESTEAD TRAILER PARK', 'HOUSTON PARK MOBILE HOME PARK',
'HUDSON MOBILE HOME PARK', 'BEACH DRIVE MOBILE HOME PARK',
'EVANS TRAILER PARK'],
'country': ['USA', 'USA', 'USA', 'USA', 'USA', 'USA', 'USA'],
'coordinates': ['30.44126118, -86.6240656099999',
'30.7190163500001, -86.5716222299999',
'30.5115772500001, -86.4628417499999',
'30.4424195300001, -86.64733076',
'30.7629176200001, -86.5928893399999', '30.44417349, -86.59951996',
'30.4427800300001, -86.62941091'],
'status':['OPEN', 'CLOSED', 'OPEN', 'OPEN', 'OPEN', 'OPEN', 'OPEN']}
df2 = pd.DataFrame(data=dd)
</code></pre>
<p>我想做的是创建一个具有以下结构的词典:</p>
<pre><code>{'destination1': 'CRESTVIEW RV PARK; 30.7190163500001, -86.5716222299999',
'destination2': 'HOMESTEAD TRAILER PARK; 30.5115772500001, -86.4628417499999',
'destination3': 'HOUSTON PARK MOBILE HOME PARK; 30.4424195300001, -86.64733076',
'destination4': 'HUDSON MOBILE HOME PARK; 30.7629176200001, -86.5928893399999',
'destination5': 'BEACH DRIVE MOBILE HOME PARK ; 30.44417349, -86.59951996'}
</code></pre>
<p>如您所见,每个值必须包含名称;从第二行到最后一行的坐标。我正在使用以下代码来执行此操作:</p>
<pre><code>d1 = {f"destination{k}":v + "; " + i for k in range(1, len(df1)-1) for v,i in zip(df1.name, df1.coordinates)}
</code></pre>
<p>然而,这是我得到的输出:</p>
<pre><code>{'destination1': 'EVANS TRAILER PARK; 30.4427800300001, -86.62941091',
'destination2': 'EVANS TRAILER PARK; 30.4427800300001, -86.62941091',
'destination3': 'EVANS TRAILER PARK; 30.4427800300001, -86.62941091',
'destination4': 'EVANS TRAILER PARK; 30.4427800300001, -86.62941091',
'destination5': 'EVANS TRAILER PARK; 30.4427800300001, -86.62941091'}
</code></pre>
<p>它只读取数据帧的最后一行,每个键都有相同的值,但我想要的是,对于每个键,它的值必须来自数据帧中从第二行到最后一行的每一行</p>
<p>如果有人知道怎么做,我会非常感谢你的帮助</p>