擅长:python、mysql、java
<p>获取具有公共值的列</p>
<pre><code>import pandas as pd
d1 = {'Beverage': ['Beverage', 'Calories', 'Fat (g)', 'Carb. (g)', 'Fiber (g)','Protein (g)', 'Sodium (g)',]}
d2 = {'Beverage': ['Beverage_category', 'Beverage', 'Beverage_prep', 'Calories', 'Fat (g)','Trans Fat (g)',
'Saturated Fat (g)', 'Sodium (g)', 'Carb. (g)', 'Cholesterol (mg)', 'Fiber (g)',
'Sugars (g)', 'Protein (g)','Vitamin A (% DV)', 'Vitamin C (% DV)', 'Calcium (% DV)',
'Iron (% DV)', 'Caffeine (mg)',]}
df1 = pd.DataFrame(d1)
df2 = pd.DataFrame(d2)
dx = pd.merge(df1, df2, on='Beverage', how='inner')
</code></pre>
<p>使代码正常工作</p>
<pre><code>print([i for i in sum(d1.values(),[]) if i in sum(d2.values(), [])])
</code></pre>