Select or extract words with a # in dataframe

Question

I recently started analyzing data with R so I am far away from good:

I collected posts on instagram, one variable (row) giving me the "title" of each post. This title is a combination of description and assigned hashtags.

I am only interested in the hashtags and want to select, extract or create a new variable only with the hashtags. I am unfamiliar with analyzing character variables, so any help is welcome!

grepl("#", your.character.vector, fixed = TRUE) – Hugh Oct 22 '17 at 10:46 — Hugh, Oct 22 '17 at 10:46

score -1 · Accepted Answer · answered Oct 22 '17 at 10:50

-1

Shot in the dark using dummy data

# Dummy data
data <- data.frame(title = c("#foo #bar",
                             "#qwerty #dvorak",
                             "#R>python"))
data$title <- as.character(data$title)
data
            title
1       #foo #bar
2 #qwerty #dvorak
3       #R>python

# Extract hashtags
grep("#", unlist(strsplit(data$title, " ")), value = TRUE)
[1] "#foo"      "#bar"      "#qwerty"   "#dvorak"   "#R>python"

answered Oct 22 '17 at 10:50

pogibas

27,303
19
84
117

1

thanks @PoGibas & @Hugh! It worked ! :) Happy sunday! – Curry79 Oct 22 '17 at 11:06
1

hashtags don't work like that. You should read the detailed discussion of why in the dup link. – hrbrmstr Oct 22 '17 at 11:35

Select or extract words with a # in dataframe

1 Answers1