Twitter - Getting account creation dates of multiple users from a csv file in Python

Question

I am trying to get creation date of Twitter accounts from a csv file. I am not sure how would I go about it. I am still learning how to code so if someone can help me with this, it'll be a great help. Thank you in advance.

from twython import Twython
import pandas as pd
import requests

t = Twython(app_key='', 
            app_secret='',
            oauth_token='',
            oauth_token_secret='')

data = "file.xlsx"
handles = pd.read_excel(data, sheet_name=None)

comma_separated_string = ",".join(data)

output = t.lookup_user(screen_name=comma_separated_string)
username_list=[]

for user in output:
username_list.append(user['created_at'])
print username_list

You'll need to give it a try first. I'd suggest you do a little searching (see [this](https://stackoverflow.com/questions/24662571/python-import-csv-to-list) post) and then when you get stuck, you'll have at least a starting point for a question. — Bill Armstrong, Jul 09 '18 at 04:35
I posted an answer, which requires your valuable suggestions. Thanks. — Kan, Jul 09 '18 at 17:58

Anadilsqa · Answer 1 · 2018-07-09T05:18:57.683

0

, As a start, You should search about how to extract data from twitter using python or extractting data from Twitter Api and you will learn how to build ur code and what you need to build it such as using Twitter access keys and tweepy library.

edited Jul 09 '18 at 05:18

answered Jul 09 '18 at 05:03

Anadilsqa

1
1

score 0 · Answer 2 · answered Jul 09 '18 at 17:57

I am using this code at the moment:

    from twython import Twython
    import pandas as pd
    import requests

    t = Twython(app_key='', 
                app_secret='',
                oauth_token='',
                oauth_token_secret='')

    data = "file.xlsx"
    handles = pd.read_excel(data, sheet_name=None)

    comma_separated_string = ",".join(data)

    output = t.lookup_user(screen_name=comma_separated_string)
    username_list=[]

    for user in output:
    username_list.append(user['created_at'])
    print username_list

Twitter - Getting account creation dates of multiple users from a csv file in Python

2 Answers2