I’m currently working on a project and need people to help me make my way around with it. I have very little knowledge about the Twitter API and it’s working. I basically need to search for a term(with exclusions of certain words) and compile the top 100 tweets found every hour or so. I’d be glad if someone who’s experienced reaches out. Thank you!

You could try using twarc for this

At a very high level: Run a twarc2 search with a cron job, extract the public_metrics from tweets, and take the top 100.

It may look like it’s aimed at academic use, but it works very well with v2 Standard Access API too

Thank you so much for your time, I’ll start here!

I have another question! I want to create a datasheet with the results and publish it on a website. How do I do that? and is there a way to automate it?

I would use twarc2 csv GitHub - DocNow/twarc-csv: A plugin for twarc2 for converting tweet JSON into DataFrames and exporting to CSV. to convert tweets into csv that can be loaded into various tools, maybe start with something like https://pandas-profiling.github.io

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.