20.读取本地excel数据
df=pd.read_excel('text2.xlsx')
# print(df)
21.查看前5行数据
print(df.head(5))
max=df['score'].max()
min=df['score'].min()
m=(max+min)/2
df['score']=m
# df=df.rename(columns={'Unnamed: 0':'aa'})
# df=df.rename(index={0:'a'})
df=df.drop('Unnamed: 0',axis=1)
# df=df.drop('score',axis=1)
df.loc[:,'score']=['18k-25k','10k-12k','1k-5k','5k-55k','4k-5k','6k-9k','9k-8k','5k-8k']
# print(df)
# lst=df['score'].split('-')
# print(lst)
# def func(df):
lst=df['score'].str.split('-')
smin=[]
for i in lst:
smin.append(int(i[0].strip('k')))#.strip('k')
smax=[]
for i in lst:
smax.append(int(i[1].strip('k')))
list=[]
for i in range(0,len(smax)):
list.append(int((smax[i]+smin[i])/2*1000))
df.loc[:,'score']=list
print(df)