Answers for "combine 2 dataframes based on equal values in columns"

combine 2 dataframes based on equal values in columns

import pandas as pd
pd.merge(df1, df2, on="Name")

#Only rows are kept for which common keys are found in both data frames. 
#In case you want to keep all rows from the left data frame and only add values from df2 
#where a matching key is available, you can use how="left":

pd.merge(df1, df2, on="Name", how="left")

pandas two dataframes equal

>>> df = pd.DataFrame({1: [10], 2: [20]})

>>> exactly_equal = pd.DataFrame({1: [10], 2: [20]}) # Note the same as above

>>> df.equals(exactly_equal)
True
# Two are the same hence true. If not would be false