🎉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

a_trunkUser: "a_trunk"
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

AI Studio
Twitter
Getting Started
Sort by:
1 - 3 of 31
    kypexinUser: "kypexin"
    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.

    a_trunkUser: "a_trunk"
    a_trunk
    New Altair Community Member
    OP

    Yes perfect! Works... Many thanks :-)

    a_trunkUser: "a_trunk"
    a_trunk
    New Altair Community Member
    OP

    Hello,

    i have one question / problem more: I count the quantities of tweets from an user, but how can i build a sum of the quantities of the tweets and a retweets? I will analyse a user which made the most tweets and also the quantities of the retweets of the users post?

    Thanks for help.

    Armin

Quick Links