Your mission:
Step 1. This software would take .csv(s) containing twitter data for a user and it's audience. Each .csv would contain the following.
-Twitter user
-Followers of that twitter user as a group
-A list of defined keywords across each account.
-The amount of times the keyword appeared for both the twitter user, and the followers of that user across the imported .csv's
Step 2. Load the .csv's into a program you create that:
-Finds the average for each keyword defined by the user across the network of .csv's
-Finds the average for each keyword (same as user keywords) for the user's followers.
Step 3. The program calculates a ratio comparing the user's audience to the the user's followers. This ratio is the "Index Score"
Step 4. The program then adds a row to the .csv that has a "index score" for each keyword for both the User and the User's followers.
In this excel contains the data..look at sheet G3 for the data you will be using for the project.
Any questions feel free.
Ryan Beatty
I am a US based consultant with immediate availability to work on your project. I look forward to working with you on this project please see PM for details regards, Paranos.