pandas 的 apply函数方法 如何获取当前行的行索引
废了好大的劲才找到 x.name
pd_insert['data_date'] = pd_insert.apply(
lambda x: get_date(x.name, x['forecast_date']), axis=1)
pandas 的Dataframe 多行多列的df
A列某行的数据若为None,则用B列的对应行数据填充
device_data_pd = easy_mysql.select_data(sql)
if not device_data_pd.empty:
# 可能是部分数据为None,把None的数据替换成和风天气的非None值
device_data_pd.columns = field_list
device_data_pd = pd.merge(left=device_pd, right=hf_data, on="device_no", how="left")
device_data_pd['temperature_value'] = device_data_pd['temperature_value'].fillna(device_data_pd['tem_avg'])
device_data_pd['humidity_value'] = device_data_pd['humidity_value'].fillna(device_data_pd['hum'])
device_data_pd["wind_speed_value"] = device_data_pd['wind_speed_value'].fillna(device_data_pd['wind_spd'])
device_data_pd["rain_fall_value"] = device_data_pd['rain_fall_value'].fillna(device_data_pd['pcpn'])
device_data_pd["pressure_value"] = device_data_pd['pressure_value'].fillna(device_data_pd['pres'])
else:
# 今天的数据为空,则去搞天气预报的数据 todo
device_data_pd = pd.merge(left=device_pd, right=hf_data, on="county_code", how="left")
device_data_pd["temperature_value"] = device_data_pd["tem_avg"]
device_data_pd["humidity_value"] = device_data_pd["hum"]
device_data_pd["wind_speed_value"] = device_data_pd["wind_spd"]
device_data_pd["rain_fall_value"] = device_data_pd["pcpn"]
device_data_pd["pressure_value"] = device_data_pd["pres"]