Error in rbind(deparse.level, ...) : numbers of columns of arguments do not match

Question

Problem :

I have about 25 dataframes which are essentially the frequency counts of my elements stored in the column called Elements. They all have some of the different and some of the the same elements in my Elements columns so they just look like below :

dataframe called DataFrame1

Elements    freq

boby         4324234

janey        433

hamy        4324

timy         22

dataframe called DataFrame1

Elements     freq

boby          987

janey         223

jonny        12

jimy          98092

I am just trying to set up the table so that my Elements becomes my column and each row is my frequencies. This is so that I should be able to combine all my dataframes.

I have tried rbind on them but facing below error:

“Error in rbind(deparse.level, ...) : numbers of columns of arguments do not match”.

Answer 1

An alternative method to the rbind + dcast technique is that the use of the tidyverse.

Please use the pipes (%>%) to first use the bind_rows() to bind all the dataframes together while simultaneously creating the dataframe id column here I just called the variable as "df". Then use the spread() to move the unique " Elements" values to become the column names and spreading your values of the "freq" across your new columns. " Elements" is the key and "freq" is your value in this case.