R-help
Never mind I figured out a working solution
- remove duplicate
- mutate a new column == 1
- spread the data from long to wide
- replace NA with 0's
Not sure it?s the most elegant but gets the gob done
-----Original Message-----
From: R-help <r-help-bounces at r-project.org> On Behalf Of Jeff Reichman
Sent: Thursday, May 6, 2021 2:37 PM
To: R-help at r-project.org
Subject: [R] Transforming data
R Help Forum
I am attempting to transform the data frame in Table 1 to the form shown in
Table 2. Any suggestions. I ve started by removing duplicate rows
Jeff
Table 1
Taxon
Importer
Guarouba guarouba
AE
Acipenser gueldenstaedtii
AE
Caiman crocodilus fuscus
AE
Caiman crocodilus fuscus
AE
Caiman crocodilus fuscus
AE
Ara ararauna
AG
Ara chloropterus
AG
Python reticulatus
AE
Strombus gigas
AE
Strombus gigas
AE
Strombus gigas
AE
Strombus gigas
AE
Strombus gigas
AE
Varanus niloticus
AE
Varanus niloticus
AE
Caiman crocodilus fuscus
AE
Table 2
Country
Guarouba guarouba
Acipenser gueldenstaedtii
Caiman crocodilus fuscus
Python reticulatus
Strombus gigas
Varanus niloticus
Caiman crocodilus fuscus
Ara ararauna
Caiman crocodilus fuscus
AE
1
1
1
1
1
1
1
0
0
AG
0
0
0
0
0
0
0
1
1
[[alternative HTML version deleted]]