gpt4 book ai didi

python - 如何避免 Pandas 将字符串转换为日期格式

转载 作者:行者123 更新时间:2023-12-04 10:59:57 25 4
gpt4 key购买 nike

我有下面的代码,它检查日期是否在开始日期和结束日期之间并返回它的文件名。

import pandas as pd
def loaddata():

global dict1
dict1 = {}

with open('load.csv', mode='r') as f:
for z in csv.DictReader(f, skipinitialspace=True):
Start_date = pd.to_datetime(z['Start_date'])
End_date = pd.to_datetime(z['End_date'])
File_type = z['File_type']
File_name = z['File_name']

if File_name not in dict1:
dict1[File_name] = {}
if File_type not in dict1[File_name]:
dict1[File_name][File_type] = (Start_date, End_date)

# dict1 gives >> {'file_name': {'type1': (Timestamp('2019-05-06 00:00:00'), Timestamp('2019-12-31 00:00:00'))},
# 'file_name1': {'type2': (Timestamp('2018-05-06 00:00:00'), Timestamp('2018-12-31 00:00:00'))}}

def fn(date, filetype):
for filename, range in dict1.items():
if filetype in range:
start, end = range[filetype]
if start <= date <= end:
return filename


new_date = pd.to_datetime('2019-12-21')
print(fn(new_date, 'type1'))
# >> returns filename

我使用 pandas 将字符串日期转换为日期格式。有没有办法在没有 Pandas 的情况下转换它?

最佳答案

当然可以:

from datetime import datetime

date_string = "2017/01/31"

date = datetime.strptime(date_string, "%Y/%m/%d")

print(date)
# datetime.datetime(2017, 1, 31, 0, 0)

关于python - 如何避免 Pandas 将字符串转换为日期格式,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/58876706/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com