将DataFrame转换为xts对象时遇UseMethod报错的技术求助

Let's break down why you're hitting that error and walk through the fixes step by step:

First, Diagnose the Root Causes #

Your error almost certainly stems from one (or both) of these issues:

1. Incorrect date format conversion: You used format("%m/%d/%Y") for a date string like 01-03-2013—this format expects slashes (/) and month-first order, but your date uses dashes (-) and looks like day-month-year (dd-mm-yyyy). This will generate NA values in your Date column, which as.xts() can't handle for the order.by argument.
2. Missing values in your data: You mentioned the first row's numerical values are null (i.e., NA). If the column you're trying to convert (df[,2]) contains NAs or non-numeric data, as.xts() will throw an error.

Step-by-Step Fixes #

1. Fix the Date Format Conversion
   Replace your date conversion line with the correct format for your date strings:

   df$Date <- as.Date(df$Date, format = "%d-%m-%Y")
   

   Verify the conversion worked by checking the first few rows:

   head(df$Date)
   

   If you still see NAs, double-check your raw date strings—some might have inconsistent formatting (e.g., mixed slashes and dashes).

2. Handle Missing Values
   Choose an approach to deal with missing values based on your data needs:

   # Option 1: Drop rows with any NA values (simple, but loses data)
   df <- na.omit(df)
   
   # Option 2: Forward-fill missing values (preserves data, using zoo package)
   # install.packages("zoo") if you haven't already
   library(zoo)
   df[, 2:ncol(df)] <- na.locf(df[, 2:ncol(df)])
   

3. Sort and Convert to xts Correctly
   Ensure you've loaded the xts package first, then run the conversion:

   library(xts)
   # Convert all numerical columns (exclude Date) to xts
   df_xts <- as.xts(df[, -1], order.by = df$Date)
   
   # If you only want the second column specifically:
   # df_xts <- as.xts(df[, 2], order.by = df$Date)
   

Verify the Fix #

Check the structure and first few rows of your new xts object to confirm it worked:

str(df_xts)
head(df_xts)

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