CSDN上的莫兰指数流程1(我觉得非常good)
import pandas as pd
import math
#经济距离矩阵构建
data = pd.read_excel('D:\槐二四\PyCharm Community Edition 2023.3.4\pgdp.xlsx',sheet_name= 0)
loc_a = list(data.loc[:,"地区"])
loc_data = []
for loc_1 in loc_a:
weight_list = []
for loc_2 in loc_a:
value_1 = data[data['地区']==loc_1]['gdp'].values[0]
value_2 = data[data['地区']==loc_2]['gdp'].values[0]
weight = 1/abs(value_1-value_2)
if math.isinf(weight):
weight = 0
else:
pass
weight_list.append(weight)
print(loc_1+'-'+loc_2+'计算完成')
loc_data.append(weight_list)
eco_weight = pd.DataFrame(loc_data,index=loc_a,columns=loc_a)
eco_weight.to_csv('经济距离矩阵.csv',encoding='gbk')
stata、pycharm、AI、