I need some tips about a pandas issue. I have the following DataFrame, df1, which contains the names in the dates that I need to keep in the output dataframe: name date column_1 column_11 Anne 2018-01-01 some info1 some info11 John 2018-01-01 some info1 some info11 Mark 2018-02-01 some info1 some info11 Ethan 2018-03-01 some info1 some info11 Anne 2018-04-01 some info1 some info11 Ethan 2018-04-01 some info1 some info11 I have this other DataFrame, df2, that contains all the names and dates in my data sample: name date column_2 column_22 Bob 2018-01-01 some info2 some info22 Bob 2018-01-01 some info2 some info22 Anne 2018-01-01 some info2 some info22 John 2018-01-01 some info2 some info22 Mark 2018-02-01 some info2 some info22 Mark 2018-02-01 some info2 some info22 Ethan 2018-03-01 some info2 some info22 Anne 2018-04-01 some info2 some info22 Anne 2018-04-01 some info2 some info22 Ethan 2018-04-01 some info2 some info22 Carl 2018-01-01 some info2 some info22 Joe 2018-01-01 some info2 some info22 And, as an output, I need a DataFrame like df1, but with all the columns in df2. Note that df1 and df2 have other columns in addition to the ones I show, thus they have different information. The thing is, I want the columns in df2, but only with the names in the dates shown in df1. Sample output would be: name date column_2 column_22 Anne 2018-01-01 some info2 some info22 John 2018-01-01 some info2 some info22 Mark 2018-02-01 some info2 some info22 Mark 2018-02-01 some info2 some info22 Ethan 2018-03-01 some info2 some info22 Anne 2018-04-01 some info2 some info22 Anne 2018-04-01 some info2 some info22 Ethan 2018-04-01 some info2 some info22 NOTE: doing: df = df2.merge(df1) Didn't work NOTE 2: df1 contains aggregated and filtered data from df2, that's why there are less rows in df1 than in df2. I just want to keep, in df2, those rows that contain the name and the date in df1. None of the solutions work, so I thought maybe this explanation would help get the right anser. Continue reading...
