R语言：将数据框month列值替换为重复的1:12序列

Hey there! Let's get that month column looping through 1 to 12 like you need. Here are a couple of reliable methods depending on your situation:

Method 1: Direct Repeat (For known number of cycles) #

Since your dataset has exactly 24 rows (two full years, each with 12 months), you can use rep() to generate the repeating sequence directly—this is the simplest approach when you know the exact number of cycles:

# Replace month with a repeated 1:12 sequence
df$month <- rep(1:12, times = 2)

Method 2: Modulo Operation (General case for any dataset size) #

If your data might grow later (with more years added), using modulo arithmetic is more flexible. It works no matter how many rows you have, as long as you need a continuous 1-12 loop. Here's a clean way to do it:

# Convert month to numeric, then adjust to loop 1-12
df$month <- (as.numeric(df$month) - 1) %% 12 + 1

Let me break this down so it makes sense:

• Subtract 1 first to shift values: 12 becomes 11, 13 becomes 12, etc.
• %% 12 gives the remainder when divided by 12—so 11%%12 stays 11, 12%%12 becomes 0.
• Add 1 back to shift everything up: 11+1=12, 0+1=1, which gives us the perfect 1-12 cycle.

Alternative Explicit Modulo Approach #

If you prefer a more readable (but slightly longer) version, you can use ifelse to handle the 0 case explicitly:

# First convert month to numeric
df$month <- as.numeric(df$month)
# Use modulo, then replace 0 with 12
df$month <- ifelse(df$month %% 12 == 0, 12, df$month %% 12)

Check the Result #

You can confirm it worked by printing the first 15 rows:

head(df, 15)

You should see the month column run 1-12, then pick back up at 1 for the second year's entries.

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