-1
I have an Excel spreadsheet with inflation expectations for 2021, 2022, 2023, 2024, 2025 over the last 30 days. When I import this spreadsheet, the dates are being considered as a column, and actually the variables should only be the years. I would need to have a data frame with 5 variables and 19 observations and not 6 variables with 19 observations. How do I make R understand that dates are not a variable?
This is the face of my data :
To import, I used this code:
expec_anual_ipca <- read_excel("expec_anual_ipca.xls")
It would be nice if you could share a sample of your data with ``dput(head(df))`, where df is your data.frame.
– Vinícius Félix
You could use a command as much as
select
to remove this column or even specify it in the import command you are using as an argument– Vinícius Félix
Hello Vinicius, thanks for the comment! But I do not want to remove, I just want the column of dates not read as a variable....
– Marcos Vinicius Laplechade