Untitled

import tweepy
import configparser
import pandas as pd
from tqdm import tqdm


# read configs
config = configparser.ConfigParser()
config.read('config.ini')

api_key = config['twitter']['api_key']
api_key_secret = config['twitter']['api_key_secret']

access_token = config['twitter']['access_token']
access_token_secret = config['twitter']['access_token_secret']

# authentication
auth = tweepy.OAuthHandler(api_key, api_key_secret)
auth.set_access_token(access_token, access_token_secret)

api = tweepy.API(auth)

# user tweets
# user = 'veritasium'
# limit=300

# tweets = tweepy.Cursor(api.user_timeline, screen_name=user, count=200, tweet_mode='extended').items(limit)

# search tweets
keywords = 'bitcoin'
limit=100

date_since ="2021-03-01"
date_until="2020-03-10"

tweets = tweepy.Cursor(api.search_tweets, q=keywords,lang="en",count=100, tweet_mode='extended').items(limit)



# create dataframe
columns = ['user_name','user_location','user_description','user_created','user_followers','user_friends','user_favourites','user_verified','date','text','source','is_retweet']

data = []
for tweet in tqdm(tweets):
    data.append([tweet.user.name, tweet.user.location, tweet.user.description,tweet.user.created_at,tweet.user.followers_count,
    tweet.user.friends_count,tweet.user.favourites_count,tweet.user.verified,tweet.created_at,tweet.full_text,tweet.source,tweet.retweeted])
    
                
df = pd.DataFrame(data, columns=columns)

df.to_csv('tweets_4.csv')
    

#tw_df = pd.DataFrame(data=tweets_df)
#print(tweets_df)
#tweets_df.to_csv('tweets_4.csv')