在熊猫中使用excel文件,我想得到非相对的日期,并在excel文件中创建标题,并放置类似“日期不相关”的注释
下面是我的代码片段:
import pandas as pd
import re
source_file = 'S://users/desktop/excel_file.xlsx'
read_file = pd.read_file(source_file)
read_file.loc[(read_file['name'] =='jones'),'comment']='jones has a dog'
read_file.loc[(read_file['Dates'] == '20-10-0019'),'comment']='date is irrelative'
举个例子,我只选了1个日期,比如“20-10-0019”。但就我而言,月份和日期都变了。但年份是恒定的,就像“0019”。我需要一个正则表达式在上面的场景中使用熊猫,得到不相关的,并把类似'日期是不相关'的评论在评论标题
输入示例:
names dates
jones 01-01-2019
politician 01-01-0019
piter nan
mike 06-10-2017
william 04-04-2018
david 19-07-0019
output be like :
nemes dates comment
jones 01-01-2019 jones has a dog
politician 01-01-0019 date is irrelative
piter nan
mike 06-10-2017
william 04-04-2018
david 19-07-0019 date is irrelative
剩余部分将为空
目前没有回答
相关问题 更多 >
编程相关推荐