我的数据框"A"看起来像这样:
type latw lngs late lngn 0 1000 45.457966 9.174864 45.458030 9.174907 1 1000 45.457966 9.174864 45.458030 9.174907 2 1000 45.458030 9.174864 45.458094 9.174907 3 1000 45.458094 9.174864 45.458157 9.174907 4 1000 45.458157 9.174864 45.458221 9.174907 5 1000 45.458221 9.174864 45.458285 9.174907 6 1000 45.458285 9.174864 45.458349 9.174907 7 1000 45.458349 9.174864 45.458413 9.174907 8 1000 45.458413 9.174864 45.458477 9.174907 9 1000 45.458477 9.174864 45.458540 9.174907 10 1000 45.458540 9.174864 45.458604 9.174907 11 1000 45.458604 9.174864 45.458668 9.174907 12 1000 45.458668 9.174864 45.458732 9.174907 13 1000 45.458732 9.174864 45.458796 9.174907 14 1000 45.458796 9.174864 45.458860 9.174907 15 1000 45.458860 9.174864 45.458923 9.174907 16 1000 45.458923 9.174864 45.458987 9.174907 17 1000 45.458987 9.174864 45.459051 9.174907 18 1000 45.459051 9.174864 45.459115 9.174907 19 1000 45.459115 9.174864 45.459179 9.174907 20 1000 45.459179 9.174864 45.459243 9.174907 21 1000 45.459243 9.174864 45.459306 9.174907 22 1000 45.459306 9.174864 45.459370 9.174907 23 1000 45.459370 9.174864 45.459434 9.174907 24 1000 45.459434 9.174864 45.459498 9.174907 25 1000 45.459498 9.174864 45.459562 9.174907 26 1000 45.459562 9.174864 45.459626 9.174907 27 1000 45.459626 9.174864 45.459689 9.174907 28 1000 45.459689 9.174864 45.459753 9.174907 29 1000 45.459753 9.174864 45.459817 9.174907 ... ... ... ... ... ... 970 1000 45.460583 9.175545 45.460647 9.175587 971 1000 45.460647 9.175545 45.460711 9.175587 972 1000 45.460711 9.175545 45.460775 9.175587 973 1000 45.460775 9.175545 45.460838 9.175587 974 1000 45.460838 9.175545 45.460902 9.175587 975 1000 45.460902 9.175545 45.460966 9.175587 976 1000 45.460966 9.175545 45.461030 9.175587 977 1000 45.461030 9.175545 45.461094 9.175587 978 1000 45.461094 9.175545 45.461157 9.175587 979 1000 45.461157 9.175545 45.461221 9.175587 980 1000 45.461221 9.175545 45.461285 9.175587 981 1000 45.461285 9.175545 45.461349 9.175587 982 1000 45.461349 9.175545 45.461413 9.175587 983 1000 45.461413 9.175545 45.461477 9.175587 984 1000 45.461477 9.175545 45.461540 9.175587 985 1000 45.461540 9.175545 45.461604 9.175587 986 1000 45.461604 9.175545 45.461668 9.175587 987 1000 45.457966 9.175587 45.458030 9.175630 988 1000 45.458030 9.175587 45.458094 9.175630 989 1000 45.458094 9.175587 45.458157 9.175630 990 1000 45.458157 9.175587 45.458221 9.175630 991 1000 45.458221 9.175587 45.458285 9.175630 992 1000 45.458285 9.175587 45.458349 9.175630 993 1000 45.458349 9.175587 45.458413 9.175630 994 1000 45.458413 9.175587 45.458477 9.175630 995 1000 45.458477 9.175587 45.458540 9.175630 996 1000 45.458540 9.175587 45.458604 9.175630 997 1000 45.458604 9.175587 45.458668 9.175630 998 1000 45.458668 9.175587 45.458732 9.175630 999 1000 45.458732 9.175587 45.458796 9.175630
它有22,000,000行×5列,有数据框"B",如下所示:
type Lat Lng 0 0 45.465739 9.180830 1 2 45.463950 9.187113 2 1 45.468015 9.180648 3 1 45.462209 9.187447 4 0 45.459578 9.184007 5 1 45.459822 9.187034 6 2 45.454988 9.180310 7 2 45.459818 9.189377 8 0 45.462200 9.187440 9 0 45.467160 9.180100 10 2 45.459407 9.183300 11 2 45.457699 9.187434 12 1 45.455319 9.186697 13 0 45.461138 9.191943 14 2 45.456397 9.189028 15 0 45.457062 9.185878 16 1 45.461980 9.187024 17 1 45.464319 9.183142 18 2 45.464227 9.187065 19 1 45.460886 9.185216
它有2,000,000行×3列.我想用"B"替换数据框"A"的类型值,其中:
A[latw]我想检查一个位于B的位置属于A中的哪一个矩形.
PS我正在寻找python中最快的方法,比如使用并行处理.