在空间分析中合并这两个数据集遇到问题
每当我尝试合并这两个数据集(TIGER/Line加州数据和CalEnviroscreen 4.0数据集)时,CalEnviroscreen 4.0的数据变量会显示为空值,而不是原来的值。这是我执行以下操作时的输出图像:
import esda
import geopandas as gpd
import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
import seaborn as sns
from libpysal import io
from libpysal import weights
from scipy import stats
np.random.seed(0)
tracts_ca = gpd.read_file("data/tl_2020_06_tract/")
tracts_ca = tracts_ca.set_index("GEOID")
tracts_ca.shape
tracts_ca.columns
tracts_ca.head()
crs = "+proj=utm +zone=11 +ellps=WGS84 +datum=WGS84 +units=m +no_defs"
tracts_ca = tracts_ca.to_crs(crs)
df_calenviroscreen = pd.read_csv("data/calenviroscreen4.csv")
df_calenviroscreen.shape
df_calenviroscreen.columns
df_calenviroscreen.head()
tracts = tracts_ca.merge(df_calenviroscreen, left_index=True, right_index=True, how="left")
tracts.shape
0 个回答
暂无回答