|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
- import pandas as pd
- import numpy as np
- name = {"name":['林莽','黄强辉','章汉夫']}
- df1 = pd.DataFrame(name)
- name =['高大山','马宏宇','林莽','章汉夫','林君雄']
- col=["python","JAVA","C"]
- df2 = pd.DataFrame(np.random.randint(0,100,size=(5, 3)),columns=col)
- df2.insert(0,"name",name)
复制代码
如果df1的名字存在于df2,将df2对应的行里面的数据输出到字典里面
"内连接" merge() 即可
- >>> df1 = pd.DataFrame({'name':['Alice', 'Bill', 'Cat']})
- >>> df1
- name
- 0 Alice
- 1 Bill
- 2 Cat
- >>> df2 = pd.DataFrame(np.random.randint(0,100, size=(5,3)), columns=['python','java', 'C'])
- >>> df2.insert(0, 'name', ['Alice', 'Bill', 'David', 'John', 'Jack'])
- >>> df2
- name python java C
- 0 Alice 32 6 19
- 1 Bill 6 96 99
- 2 David 60 69 36
- 3 John 89 86 45
- 4 Jack 68 33 80
- >>> df1.merge(df2, how='inner', on='name')
- name python java C
- 0 Alice 32 6 19
- 1 Bill 6 96 99
- >>>
复制代码
|
|