It is a dta file, can not be read with read.csv. I used haven to read it. However, the second row of column is real name, such as Checking Year and Checking Month , how can you extract it?
Jochen Wilhelm Thank you for your timely reply. I have used haven to read it, and the picture is the dataframe in R. Could you kindly suggest how to extract real name.
Jochen Wilhelm Thank you for your advice. I do find the label attribute of this tibble data frame. However, could you kindly suggest how to extract label name of all columns in a dataframe?
Jochen Wilhelm Sorry to make you misunderstanding my questions. I want to extract all labels of those columns as column names. For example, we want extract label names: Individual id, Household ID, Community ID, Checking Year, Checking Season, Checking Date, Checking Day. And Set those names as column names.
Please contact me if more information was needed :)