33 野に咲く名無し@転載禁止 2024/03/01 (金) 22:05:53.197 ID:67r4OKEOr
# txtは別途utf-8に変換してね
import pandas as pd
import re
import datetime
with open("./subject.txt") as f:
l = f.readlines()
df = pd.DataFrame(l, columns=［"data"］)
df = df［"data"］.str.extract(r"^(\d+)\.dat<>(.+)\(1\)$")
df.rename(columns={0: "date", 1: "title"}, inplace=True)
df［"date"］ = df［"date"］.astype(int).apply(lambda x: datetime.datetime.fromtimestamp(x))