R- Is there a way to separate vectors in a column by a delimiter into new column headers with 1's for columns that have the specified vector?

Asked Jan 30 '23 at 23:21

Active Jan 30 '23 at 23:21

Viewed 14 times

I am working in R studio and currently have this as a field for a column:

row 1: SA * OP OIT ORT * PC row 2: SA DT * ACMA * PC

I would like to have this

SA DT ACMA OP OIT ORT PC 1 na na 1 1 1 1 1 1 1 na na na 1

I have tried using separate() but do knot know the number of columns possible as it is a very large dataset and this does not address the issues of 1 vs. a character. This would also make it challenging/tedious to use grep or some sort of other specific call-outs.

asked Jan 30 '23 at 23:21

Rose Goren

1

Hello Rose, perhaps you may clarify the question, use [tables](https://meta.stackexchange.com/questions/356997/new-feature-table-support) for express your desired output. Use `dput(your_data)` and copy/paste the output to share you data for better understanding. – Ric Jan 30 '23 at 23:36

R- Is there a way to separate vectors in a column by a delimiter into new column headers with 1's for columns that have the specified vector?

0 Answers0