R的包tidyr--数据清洗

Overview of tidyr

** R package

**Apply the principles of tidy data

** Small set of the simple functions

gather columns into key-value pairs

-> wide_df

->gather(wide_df,my_key,my_value,-col)

gather(data,key,value,..)

data: a data frame

key: bare name of the new key column

value:bare name of the new value column

...:bare names of the columns to gather (or not), if not, use the -column

spread(data,key,value)

data:a data frame

key:bare name of columns containing keys

value:bare name  of columns containing value

sparate(data,col,into)

data:a data frame

col: bare name of column to separate

into:character vector of new column names

eg: separate(treatments, year_mo, c("year","month"))

sep ="-"

Unite

unite(data,col,...)

data:a data frame

col:bare name of new column

...:column name need to be united

unite(treatmnents, year_mo, year,month)