Challenge #56: Parsing and Counting Hashtags

[jarrod]

tough one in python, pretty straight forward in Alteryx though 🙂

Spoiler

from ayx import Alteryx
import pandas as pd
import numpy as np

data = Alteryx.read('#1')
data['hashtags'] = data['text'].str.findall('(#\w+)').astype(str).str.replace('[','').str.replace(']','').str.replace("'",'')

data = pd.concat([pd.Series(row['id_str'], row['hashtags'].split(','))              
                    for _, row in data.iterrows()]).reset_index()

data = data.rename(columns={'index':'hashtags', 0:'id_str'})
data['hashtags'] = data['hashtags'].str.replace(' ','')
data = data[data['hashtags']!=u'']
data = pd.crosstab(data.hashtags, data.id_str).reset_index()

data

#SnakingMyWayThruChallenges

[JonathanW]

Solved!

Spoiler

[chinedu]

my solution

[dougperez]

My solution!

Spoiler

[Blake]

Spoiler

[iamme012397]

no need for parsing formula

[jaschirmer]

Here's my solution.

[alynnreau]

Spoiler

[FlorianC]

Interesting to see all the different approaches to solve this challenge.

Spoiler

Workflow

[JethroChen]

Spoiler