大冶灵乡

import pandas as pd
from datetime import timedelta

data1=pd.read_csv(r"C:\Users\HsqxtWwf\example\lx1.txt",header=0,sep="\s+")
data2=pd.read_csv(r"C:\Users\HsqxtWwf\example\lx2.txt",header=0,sep="\s+")
data=pd.concat([data1,data2])
data["DateTime"]=data["Date"]+" "+data["Time"]

data["DateTime"]=pd.to_datetime(data["DateTime"])

data["DateTime_bj"] = data["DateTime"]+timedelta(hours=8)

data.to_excel(r"C:\Users\HsqxtWwf\example\lx.xlsx")