R, how to create a table from a list of occurrences?

Asked Sep 30 '19 at 19:03

Active Sep 30 '19 at 19:03

Viewed 117 times

I have a csv file where each occurrence contains two ID's and a number to associate them. I want to do something simple: I want to create a table where I have the list of the first ID's as rows and the list of the second ID's as columns, and each entry is the numeric value.

Please see the following image:

I read the file into a dataframe, tried to follow this answer and use melt() but did not succeed.

df_long = melt(data_table, id.vars = "value")

How can I create this table? Thanks!

asked Sep 30 '19 at 19:03

DavideChicco.it

3,318
13
56
84

1

Looks like you can use `xtabs(col3 ~ col2 + col1, df1)` – akrun Sep 30 '19 at 19:09
You could also: `tidyr::spread(df, col1, col3)` – Andrew Sep 30 '19 at 19:13
or `tidyr::pivot_wider`, which is supposed to replace `spread` – astrofunkswag Sep 30 '19 at 19:16

R, how to create a table from a list of occurrences?

0 Answers0