不知道我在这里做错了什么,但我想用column_names列表中的相应名称替换初始列名称。
column_names = ['FIPS','Admin2','Province_State','Country_Region','Last_Update','Lat','Long_','Confirmed','Deaths','Recovered','Active','Combined_Key']
df.columns = ['Province/State', 'Country/Region', 'Last Update', 'Confirmed',
'Deaths', 'Recovered', 'Latitude', 'Longitude']
def replace_cols(df, new_columns):
k = 0
for i in df.columns:
for j in column_names:
seq = difflib.SequenceMatcher(None,i, j).ratio()*100
if seq >= 50:
newcol = re.sub(i, j, i)
df.columns.values[k] = newcol
print(newcol)
k += 1