python将Excel内容的替换

Excel内容的替换

#!/usr/bin/python3.6
# -*- coding: utf-8 -*-
# @Time    : 2022/8/18 15:55
# @Author  : Admin@123
# @Email   : xxxxxxxxxxx@xxx.com
# @Phone   : 199XXXX782X/191XXXX972X
# @File    : 筛选.py
# @Software: PyCharm
import pandas as pd
import datetime

input("请输入时间:格式如:2022-08-01")
time_input = input("时间:")

today = datetime.datetime.now().strftime('%Y-%m-%d')
df_zt = pd.read_excel('20220816-new.xls')
# 机场名称广州替换为广州白云机场
df_zt['机场名称'] = df_zt['机场名称'].str.replace('广州', '广州白云机场').fillna(df_zt['机场名称'])

print(df_zt)
df['时间'] = pd.to_datetime(df['时间']).dt.strftime('%Y-%m-%d')

df_zt['派单'] = pd.to_datetime(df_zt['派单']).dt.strftime('%Y-%m-%d')
df1 = pd.DataFrame()
# df1 = df.loc[df['时间'] < '2022-08-17']
df1 = df_zt.loc[df_zt['派单'] >= str(time_input)]
print(df1)