🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Twitter Textmining User Count

User: "a_trunk"
New Altair Community Member
Updated by Jocelyn

Hello, i am a Newbie and work with rapid miner for education. No i have a question where i need help:

I have to textmining twitter by a special keyword. It works easy. But now i want to select only the user, which post more than 3 tweets in the selection. So how i have to build in a querry <3 or similar? And how can i sort them in the result from most tweets to only one tweet?

I try some different solution but i did not find a answer...

 

Best regards and many thanks

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "kypexin"
    New Altair Community Member
    Accepted Answer

    Hi @a_trunk

     

    The easiest way to do it is to use aggregation. 

    For example, let's assume you have a very simple dataset format, "USER | TWEET" (one column is username and second a tweet text). 

    So, you can use Aggregate operator then, in parameters choose 'group by attributes' = 'user' and 'aggregation attributes' = 'count(tweet)'.

    This way you will get a list of users each with a total number of their tweets.