I have the following problem
import pandas as pd
import numpy as np
data = {
"ID": [420, 380, 390, 540,520],
"duration": [50, 40, 45,33,19],
"previous": [125 , 540 , 420 , 777 , 390 ],
"next":[390,880 ,520 ,380 ,810 ]
}
#load data into a DataFrame object:
df = pd.DataFrame(data)
print(df)
#search for IDs where previous are not in IDs
#print(data[~data['previous'].isin(data['ID'])])
#print(data[~data.previous.isin(data.ID)])
print(data[~data.next.isin(data.ID)])
As you can see I have a dataframe
ID duration previous next
0 420 50 125 390
1 380 40 540 880
2 390 45 420 520
3 540 33 777 380
4 520 19 390 810
and I want to find the rows where the "next" (or the "previous") data is not in the IDs
for example the row 0 has a previous (125) which does not exist in IDs or the row 4 has a next(810) which does not exist in IDs
I tried to apply this solution but I get the error "AttributeError: 'dict' object has no attribute 'next'"