I have imported both files, but they have different column names and the excel file has more observations. How do i combine these two files into one dataframe?
Do you want to combine the two data frames row-wise or column-wise?
If it is row-wise, is the only problem that the column names do not match? You can change the column names using the colnames() function and then use rbind().
If you want to join the data frames column-wise, you can use one of *_join functions from dplyr, probably left_join but you need to choose which columns will control the join.
If you provide short examples of your data and explain how you want to combine them, someone could give you more detailed guidance. You can paste the output of the dput() function to provide data samples. For example, if a data frame is named DF, paste the output of dput(head(DF))
between lines of three back ticks.
```
your output here
```
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.