|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
import pandas as pd
# 读取Excel文件
input_file_path = r'C:\Users\Administrator\Desktop\论文1综述\知网802.xls'
output_file_path = r'C:\Users\Administrator\Desktop\论文1综述'
try:
df = pd.read_excel(input_file_path)
print(f"成功读取文件:{input_file_path}")
except Exception as e:
print(f"读取文件时发生错误:{e}")
exit()
# 提取Keyword-关键词列和Year-年列
try:
keywords = df['Keyword-关键词']
years = df['Year-年']
print("成功提取关键词和年份列")
except Exception as e:
print(f"提取列时发生错误:{e}")
exit()
# 初始化字典来存储关键词及其出现次数和年份列表
keyword_data = {}
# 遍历每行数据
for index, (keyword_str, year) in enumerate(zip( |
|