I want to remove rows in df1 which have common numbers in the "0" columns of both df's
df1 = pd.read_csv('Displacement.txt', sep="\s", header=None)
df2= pd.read_csv('overconstraint.txt', header=None)
df1 (>6million rows) looks like
0 1 2 3 4 5 6
0 1 , 1 , 1.0 , 1.8800E-01
1 2 , 1 , 1.0 , 1.8491E-01
df2 (>1000 rows) looks like
0
0 1119933
1 1119933
2 1122062
How to do this?