r - 如何提取两个 DateTime 列的月份并仅使用提取的月份创建两个新列?
问题描述
有谁知道我如何制作两个新列,其中只有附件中显示的列的 DateTime 月份?
"February", "February",
"February", "February", "February", "June", "June", "June",
"June", "January", "January", "January", "February", "February",
"February", "February", "February", "March", "June", "June",
"June", "October", "October", "October", "October", "October",
"January", "January", "January", "February", "February",
"February", "January", "January", "January", "June", "October",
"October", "October", "February", "February", "February",
"February", "September", "May", "May", "May", "April", "April",
"April", "April", "May", "April", "April", "May", "November",
"June", "June", "June", "November", "September", "June",
"June", "June", "February", "February", "September", "September",
"June", "March", "March", "August", "April", "April", "April",
"April", "April", "April", "April", "August", "September",
"September", "September", "September", "September", "September",
"November", "October", "April", "October", "April", "April",
"August", "August", "August", "August", "August", "December",
"April", "April", "April", "April", "April", "April", "August",
"August", "August", "August", "August", "December", "December",
"December", "December", "March", "March", "March", "July",
"July", "July", "February", "February", "February", "February",
"March", "March", "March", "March", "March", "March", "March",
"September", "September", "August", "February", "February",
"February", "February", "March", "March", "March", "April",
"April", "February", "February", "February", "April", "June",
"June", "May", "May", "May", "May", "October", "October",
"October", "October", "October", "March", "March", "March",
"October", "October", "October", "October", "August", "August",
"August", "August", "September", "July", "January", "January",
"January", "January", "January", "January", "June", "December",
"October", "October", "October", "May", "May", "May", "May",
"July", "April", "April", "April", "April", "January", "January",
"January", "January", "January", "September", "September",
"September", "September", "March", "March", "March", "March",
"September", "September", "September", "September", "April",
"October", "April", "April", "April", "April", "January",
"February", "February", "February", "February", "June", "June",
"June", "November", "November", "November", "November", "November",
"January", "January", "February", "February", "February",
"February", "February", "September", "September", "September",
"September", "September", "September", "February", "July",
"July", "July", "July", "March", "March", "March", "March",
"February", "November", "July", "July", "July", "July", "July",
"July", "July", "July", "February", "February", "February",
"December", "February", "January", "February", "March", "January",
"February", "February", "February", "February", "February",
"January", "June", "January", "January", "December", "December",
"December", "December", "January", "January", "December",
"December", "March", "March", "June", "March", "March", "March",
"March", "July", "July", "August", "January", "January",
"January", "January", "January", "January", "January", "January",
"January", "January", "January", "January", "July", "May",
"May", "October", "October", "July", "July", "July", "July",
"July", "January", "April", "April", "November", "November",
"November", "November", "November", "November", "November",
"November", "November", "September", "November", "November",
"April", "April", "April", "April", "April", "April", "April",
"April", "April", "April", "April", "April", "April", "April",
"April", "January", "January", "January", "January", "November",
"July", "July", "July", "July", "February", "February", "February",
"December", "February", "December", "December", "April",
"April", "April", "April", "April", "April", "April", "April",
"March", "March", "March", "December", "December", "December",
"March", "March", "March", "March", "March", "March", "June",
"April", "April", "April", "March", "March", "March", "March",
"March", "January", "July", "July", "July", "July", "July",
"February", "February", "October", "February", "February",
"February", "February", "October", "October", "October",
"June", "June", "June", "June", "January", "January", "January",
"January", "June", "June", "June", "June", "June", "June",
"January", "January", "January", "October", "October", "October",
"October", "January", "January", "January", "June", "June",
"June", "June", "June", "June", "October", "October", "February",
"February", "February", "April", "March", "May", "May", "May",
"February", "July", "April", "April", "April", "April", "June",
"May", "March", "May", "April", "April", "April", "April",
"November", "November", "January", "January", "June", "June",
"June", "June", "June", "April", "September", "June", "June",
"February", "February", "September", "June", "March", "March",
"March", "April", "April", "April", "April", "April", "April",
"April", "April", "September", "September", "November", "November",
"April", "April", "April", "April", "May", "May", "March",
"March", "March", "August", "August", "August", "August",
"August", "April", "April", "April", "March", "March", "March",
"March", "December", "December", "March", "March", "March",
"July", "April", "April", "April", "April", "April", "March",
"March", "September", "September", "August", "August", "August",
"August", "August", "August", "August", "February", "February",
"February", "February", "February", "March", "March", "April",
"April", "April", "April", "June", "February", "February",
"August", "August", "October", "October", "October", "August",
"August", "September", "October", "October", "October", "August",
"August", "September", "August", "July", "October", "October",
"July", "July", "July", "August", "August", "September",
"June", "January", "January", "October", "October", "October",
"October", "July", "July", "January", "November", "January",
"January", "January", "January", "October", "October", "October",
"July", "January", "January", "January", "January", "September",
"September", "September", "January", "January", "July", "September",
"September", "September", "January", "January", "January",
"January", "March", "March", "March", "March", "September",
"September", "October", "October", "February", "February",
"July", "July", "July", "July", "July", "November", "November",
"November", "February", "February", "February", "February",
"February", "January", "January", "January", "January", "September",
"September", "September", "February", "February", "March",
"March", "November", "July", "July", "December", "July",
"July", "July", "July", "July", "March", "March", "March",
"February", "February", "February", "February", "February",
"May", "April", "April", "July", "July", "July", "July",
"July", "March", "March", "February", "February", "February",
"January", "February", "March", "March", "January", "June",
"June", "December", "December", "June", "February", "February",
"January", "April", "April", "April", "April", "April", "April",
"January", "January", "February", "January", "January", "January",
"January", "January", "January", "January", "April", "April",
"April", "April", "April", "April", "July", "July", "July",
"April", "September", "September", "October", "April", "January",
"February", "February", "November", "November", "November",
"September", "November", "November", "November", "November",
"November", "November", "November", "November", "November",
"November", "April", "April", "April", "November", "March",
"March", "April", "January", "January", "January", "January",
"January", "July", "July", "July", "February", "February",
"December", "December", "February", "December", "December",
"April", "April", "April", "April", "April", "March", "March",
"December", "December", "March", "March", "March", "June",
"June", "June", "June", "June", "June", "April", "April",
"April", "April", "March", "March", "March", "March", "March",
"March", "March", "March", "July", "July", "October", "October",
"February", "February", "February", "February", "February",
"October", "June", "June", "June", "June", "January", "January",
"June", "June", "January", "January", "January", "January",
"October", "October", "October", "January", "January", "June",
"June", "October", "March", "March", "February", "May", "May",
"April", "February", "July", "July", "April", "April", "April",
"April", "June", "May", "May", "March", "May", "April", "April",
"April", "April", "April", "April", "April", "November",
"November", "November", "June", "June", "June", "November",
"November", "September", "June", "June", "June", "June",
"February", "February", "February", "September", "June",
"April", "September", "September", "April", "April", "May",
"May", "May", "May", "April", "March", "March", "March",
"March", "March", "March", "August", "August", "August",
"August", "August", "August", "August", "August", "August",
"December", "April", "April", "April", "April", "March",
"March", "March", "December", "April", "April", "April",
"March", "March", "March", "July", "July", "April", "April",
"April", "March", "March", "March", "March", "March", "March",
"September", "September", "September", "September", "August",
"August", "August", "August", "February", "February", "February",
"March", "March", "March", "April", "June", "June", "February",
"February", "August", "October", "October", "October", "October",
"October", "August", "August", "August", "August", "August",
"October", "October", "October", "October", "October", "October",
"August", "September", "September", "August", "August", "October",
"August", "August", "December", "January", "January", "January",
"January", "January", "January", "October", "October", "October",
"October", "October", "October", "July", "July", "January",
"November", "January", "January", "January", "January", "October",
"October", "October", "October", "October", "July", "January",
"January", "January", "January", "January", "January", "September",
"January", "July", "July", "June", "June", "September", "September",
"September", "September", "January", "January", "January",
"January", "March", "March", "March", "September", "September",
"October", "October", "October", "October", "February", "February",
"February", "February", "February", "February", "July", "July",
"July", "July", "July", "November", "November", "November",
"November", "February", "February", "February", "February",
"January", "January", "January", "January", "January", "November",
"November", "July", "July", "July", "July", "June", "June",
"July", "July", "July", "July", "July", "March", "March",
"March", "March", "March", "February", "February", "December",
"December", "December", "December", "April", "April", "April",
"April", "April", "February", "March", "March", "March",
"March", "February", "February", "February", "February",
"February", "February", "February", "March", "January", "January",
"January", "January", "February", "February", "January",
"January", "January", "March", "March", "January", "January",
"January", "January", "June", "December", "January", "January",
"January", "January", "July", "August", "February", "January",
"January", "January", "January", "April", "April", "April",
"January", "January", "January", "January", "January", "January",
"January", "January", "July", "January", "April", "April",
"July", "July", "July", "July", "July", "July", "July", "June",
"September", "September", "October", "April", "April", "February",
"April", "September", "November", "November", "November",
"November", "November", "November", "November", "September",
"September", "September", "September", "November", "April",
"April", "April", "March", "April", "April", "January", "January",
"July", "July", "July", "July", "July", "July", "February",
"December", "December", "December", "December", "February",
"February", "February", "December", "December", "April",
"April", "April", "April", "March", "March", "March", "March",
"March", "March", "December", "March", "March", "June", "June",
"June", "May", "April", "April", "April", "March", "March",
"March", "March", "July", "July", "July", "February", "February",
"February", "October", "October", "October", "February",
"February", "October", "October", "June", "June", "June",
"June", "January", "January", "January", "January", "January",
"January", "January", "June", "June", "June", "June", "June",
"January", "January", "January", "January", "October", "October",
"October", "January", "January", "January", "June", "June",
"October", "May", "May", "July", "February", "February",
"April", "April", "April", "April", "April", "March", "May",
"April", "April", "May", "June", "June", "June", "June",
"June", "June", "June", "June", "June", "February", "February",
"September", "September", "September", "October", "August",
"August", "August", "September", "September", "September",
"November", "November", "October", "April", "October", "October",
"October", "May", "May", "April", "April", "April", "April",
"April", "March", "March", "March", "March", "August", "August",
"August", "August", "August", "August", "April", "April",
"April", "April", "April", "April", "April", "April", "April",
"April", "April", "March", "March", "December", "December",
"December", "April", "March", "March", "March", "March",
"July", "July", "July", "July", "April", "April", "April",
"April", "March", "September", "September", "September",
"August", "August", "August", "August", "August", "August",
"August", "February", "February", "February", "March", "March",
"March", "March", "March", "April", "June", "June", "February",
"February", "February", "February", "August", "August", "August",
"October", "October", "October", "August", "August", "September",
"September", "September", "October", "October", "October",
"August", "August", "August", "October", "October", "October",
"June", "September", "September", "June", "December", "January",
"January", "January", "January", "January", "January", "October",
"July", "November", "November", "January", "January", "January",
"January", "January", "January", "October", "January", "January",
"January", "September", "September", "July", "July", "July",
"July", "September", "September", "September", "January",
"January", "January", "March", "March", "March", "September",
"September", "September", "September", "October", "February",
"June", "July", "July", "July", "November", "February", "January",
"November", "October", "January", "January", "January", "November",
"July", "July", "July", "July", "July", "July", "July", "July",
"July", "July", "July", "March", "March", "March", "February",
"February", "February", "February", "February", "February",
"February", "December", "October", "April", "April", "April",
"April", "April", "July", "July", "July", "July", "July",
"March", "March", "March", "March", "February", "February",
"February", "February", "February", "November", "November",
"February", "February", "February", "February", "March",
"January", "January", "January", "January", "January", "January",
"January", "January", "February", "February", "January",
"March", "January", "June", "January", "January", "June",
"June", "December", "January", "July", "July", "February",
"January", "January", "January", "January", "April", "April",
"April", "April", "April", "April", "January", "January",
"January", "January", "January", "January", "January", "January",
"January", "January", "April", "April", "April", "April",
"November", "October", "October", "July", "July", "July",
"July", "July", "September", "April", "January", "January",
"April", "April", "February", "February", "February", "September",
"November", "November", "November", "November", "September",
"September", "September", "September", "September", "November",
"April", "April", "April", "April", "March", "April", "April",
"April", "April", "January", "January", "January", "July",
"July", "July", "May", "May", "February", "December", "December",
"April", "April", "April", "April", "April", "March", "March",
"March", "March", "December", "December", "March", "March",
"March", "June", "June", "May", "April", "April", "April",
"April", "April", "April", "March", "March", "March", "March",
"July", "July", "July", "July", "February", "February", "February",
"October", "October", "October", "October", "February", "February",
"February", "October", "October", "October", "October", "June",
"June", "January", "January", "January", "June", "June",
"June", "June", "June", "June", "June", "June", "January",
"January", "January", "January", "January", "January", "November",
"November", "October", "October", "October", "October", "January",
"January", "June", "June", "June", "June", "June", "June",
"June", "October", "March", "May", "May", "July", "July",
"July", "July", "April", "May", "July", "April", "April",
"April", "April", "May", "May", "March", "January", "June",
"November", "September", "June", "June", "June", "June",
"June", "June", "June", "June", "April", "June", "March",
"September", "April", "April", "April", "April", "April",
"October", "October", "May", "May", "May", "April", "April",
"April", "March", "March", "March", "March", "March", "August",
"August", "August", "April", "April", "April", "April", "April",
"April", "April", "March", "March", "March", "March", "March",
"March", "March", "December", "December", "April", "April",
"March", "March", "March", "March", "March", "April", "March",
"March", "March", "March", "September", "August", "August",
"August", "February", "February", "February", "March", "March",
"March", "March", "March", "April", "April", "April", "April",
"April", "April", "June", "February", "February", "February",
"February", "February", "February", "October", "October",
"October", "August", "August", "August", "August", "September",
"October", "October", "October", "October", "August", "August",
"August", "September", "August", "October", "June", "June",
"January", "January", "January", "October", "July", "January",
"January", "November", "November", "January", "January",
"July", "January", "January", "January", "January", "January",
"September", "May", "May", "May", "January", "June", "September",
"September", "September", "September", "September", "September",
"January", "March", "March", "March", "March", "September",
"September", "September", "January", "January", "January",
"January", "January", "October", "October", "October", "October",
"October", "February", "February", "February", "February",
"August", "June", "June", "July", "July", "July", "July",
"July", "November", "February", "February", "February", "February",
"February", "February", "March", "March", "March", "January",
"July", "July", "July", "July", "July", "July", "July", "March",
"March", "February", "February", "February", "February",
"February", "December", "October", "December", "May", "April",
"February", "February", "February", "July", "July", "July",
"March", "February", "February", "February", "February",
"February", "February", "February", "February", "February",
"November", "November", "November", "February", "January",
"January", "January", "January", "January", "February", "January",
"March", "March", "January", "January", "December", "January",
"July", "July", "February", "January", "January", "January",
"April", "April", "April", "April", "April", "January", "February",
"January", "January", "July", "January", "April", "April",
"April", "October", "July", "July", "July", "July", "July",
"July", "April", "September", "October", "April", "April",
"September", "September", "November", "November", "November",
"November", "November", "November", "November", "September",
"September", "September", "November", "April", "April", "April",
"April", "April", "April", "April", "November", "November",
"March", "April", "April", "April", "April", "April", "January",
"February", "February", "February", "February", "February",
"February", "October", "May", "April", "April", "April",
"April", "July", "July", "July", "July", "July", "July",
"March", "March", "March", "March", "March", "March", "February",
"February", "February", "February", "November", "February",
"February", "January", "January", "February", "December",
"February", "February", "January", "January", "January",
"March", "January", "January", "January", "January", "January",
"December", "December", "January", "July", "November", "November",
"November", "February", "February", "January", "April", "January",
"January", "January", "April", "April", "April", "April",
"April", "April", "May", "May", "November", "November", "November",
"November", "January", "January", "January", "January", "January",
"July", "April", "April", "April")), .Names = c("ChargeSession_skey",
"Transaction_ID", "Provider", "Location_skey", "ChargePoint_skey",
"RFID_skey", "UseType", "UseTypeCompany", "ServiceProvider",
"Car_skey", "StartDate_skey", "EndDate_skey", "ChargePoint_ID",
"Socket_ID", "StartConnectionDateTime", "EndConnectionDateTime",
"ConnectionTimeHours", "ChargeTimeHours", "kWh", "LoadDateTime",
"IsValid", "Remark_skey", "NrOfRowsInvolved", "Country", "State",
"Region", "City", "Address", "PostalCode", "District", "SubDistrict",
"SubSubDistrict", "SubSubSubDistrict", "DistrictCode", "SubDistrictCode",
"SubSubDistrictCode", "SubSubSubDistrictCode", "Latitude", "Longitude",
"IsGarage", "NameGarage", "Month1"), row.names = c(NA, -103540L
), class = "data.frame")
解决方案
尝试这个:
#Data
df <- data.frame(Start='2020-07-31 23:06:05.0',
End='2020-08-31 23:06:05.0',stringsAsFactors = F)
#Code
df$Month1 <- format(as.POSIXct(df$Start,format='%Y-%m-%d %H:%M:%S',tz = 'GMT'),"%B")
df$Month2 <- format(as.POSIXct(df$End,format='%Y-%m-%d %H:%M:%S',tz = 'GMT'),"%B")
输出:
df
Start End Month1 Month2
1 2020-07-31 23:06:05.0 2020-08-31 23:06:05.0 July August