I have a grouped data frame named df_grouped
where AF
& Local
are the indexes. I would like to assert whether the indexes in df_grouped
are equal to a column from another dataframe df[A]
.
This is an example of my code
JavaScript
x
10
10
1
import pandas as pd
2
3
data = {'Number': [5678, 2934],
4
'Age': [93, 88],}
5
df_grouped= pd.DataFrame(data, index=["AF","Local"])
6
7
data2 = {"A":["AF","Local"],
8
"Location":["US","China"]}
9
df=pd.DataFrame(data2)
10
I tried this but it does not work:
JavaScript
1
2
1
assert df["A"].isin(df_grouped.index)
2
Advertisement
Answer
To use assert for pandas series you can use assert_series_equal
which checks that left and right Series are equal.
JavaScript
1
3
1
from pandas import testing as tm
2
tm.assert_series_equal(df["A"], df_grouped.index.to_series(index=df["A"].index, name= df["A"].name))
3
which will give you error if series values are different.
AssertionError: Series.index are different