Exploratory question: if I have a dataframe A with a column Person_Id, and each row in Person_Id is a person_id, and I have another dataframe B where the index is Person_Id, and the columns are info related to that person_id, is there a nice way to quickly reference dataframe B when I access Person_Id dataframe A?
Asked
Active
Viewed 231 times
0
A1122
- 1,324
- 3
- 15
- 35
-
see [pandas-merging-101](https://stackoverflow.com/questions/53645882/pandas-merging-101) – Anurag Dabas Jul 30 '21 at 13:31
-
1No, you have to merge your dataframes. Dataframes are not a relational database. – Corralien Jul 30 '21 at 13:31
-
Without using any of the merge functions – A1122 Jul 30 '21 at 13:33
-
see https://stackoverflow.com/a/40429755/14289892 or [remap-values-in-pandas-column-with-a-dict](https://stackoverflow.com/questions/20250771/remap-values-in-pandas-column-with-a-dict) – Anurag Dabas Jul 30 '21 at 13:33
-
1Why don't you want to use `merge`? Is this homework? – mozway Jul 30 '21 at 13:44