擅长:python、mysql、java
<p>参见埃德丘姆对<a href="https://stackoverflow.com/questions/29794959/pandas-add-new-column-to-dataframe-from-dictionary">this Stack Overflow question</a>的回答。在</p>
<p>根据您的情况,它看起来像:</p>
<pre><code>import pandas as pd
# create dictionary
d = {'umls1':'snomed1','umls2':'snomed2','umls3':'snomed3'}
# create empty dataframe
columns = ['symptom','umls','snomed']
df = pd.DataFrame(columns = columns)
# fill it with symptoms and with umls, with some umls NULL
df['symptom'] = ['nausea','muscle','headache','pain','bitter']
df.ix[0,'umls'] = 'umls1'
df.ix[1,'umls'] = 'umls2'
df.ix[4,'umls'] = 'umls3'
# add a third column with snomed values from dictionary
df['snomed'] = df['umls'].map(d)
</code></pre>
<p>给出以下输出:</p>
^{pr2}$