如何将yyyymmdd格式的数值型日期向量转换为mm-dd-yyyy文本格式？

Hey there! Converting that numeric date vector to your desired mm-dd-yyyy text format is totally doable with a few lines of code, depending on which language you're using. Let's walk through the most common tools for R and Python—since those are the go-to for this kind of data work.

R Options #

Base R (No Extra Packages Needed) #

First, convert your numeric values to character strings, then parse them as dates and reformat:

# Example numeric date vector
num_dates <- c(20101224, 20230515, 20190101)

# Convert to mm-dd-yyyy text
text_dates <- format(strptime(as.character(num_dates), "%Y%m%d"), "%m-%d-%Y")

print(text_dates)
# Output: "12-24-2010" "05-15-2023" "01-01-2019"

Using lubridate (Cleaner & More Intuitive) #

If you already use the lubridate package (a must-have for date handling in R), this is even simpler:

library(lubridate)

num_dates <- c(20101224, 20230515, 20190101)
text_dates <- format(ymd(num_dates), "%m-%d-%Y")

print(text_dates)

The ymd() function automatically recognizes numeric/character inputs in year-month-day order, and format() lets you tweak the output to exactly what you need.

Python Options #

pandas (Best for Vector/Column Data) #

If you're working with a pandas Series (like a column in a DataFrame), this method is efficient and robust:

import pandas as pd

# Sample numeric date series
num_dates = pd.Series([20101224, 20230515, 20190101])

# Two approaches: string slicing (fast) or datetime parsing (safer)
# String slicing
text_dates_sliced = num_dates.astype(str).apply(lambda x: f"{x[4:6]}-{x[6:8]}-{x[0:4]}")

# Datetime parsing (handles invalid dates better)
text_dates_parsed = pd.to_datetime(num_dates, format="%Y%m%d").dt.strftime("%m-%d-%Y")

print(text_dates_parsed)
# Output:
# 0    12-24-2010
# 1    05-15-2023
# 2    01-01-2019
# dtype: object

Python's Built-in datetime Module (For Lists) #

If you're dealing with a regular Python list instead of pandas, use the datetime module:

from datetime import datetime

num_dates = [20101224, 20230515, 20190101]
text_dates = [datetime.strptime(str(date), "%Y%m%d").strftime("%m-%d-%Y") for date in num_dates]

print(text_dates)
# Output: ['12-24-2010', '05-15-2023', '01-01-2019']

内容的提问来源于stack exchange，提问作者QFi