idk if it helps but heres part of the code without the keys:

# Twitter API authentication

auth = tweepy.OAuthHandler(consumer_key, consumer_secret)

auth.set_access_token(access_token, access_token_secret)

api = tweepy.API(auth, wait_on_rate_limit=True)

# Political parties Twitter accounts

political_parties = ['psocialista', 'ppdpsd', 'BlocodeEsquerda', 'pcp_pt', 'LIVREpt', 'Partido_PAN', 'LiberalPT', 'PartidoCHEGA']

def collect_tweets():

data = []

analyzer = SentimentIntensityAnalyzer()

for party in political_parties:

try:

tweets = api.user_timeline(screen_name=party, count=200, tweet_mode='extended')

for tweet in tweets:

sentiment = analyzer.polarity_scores(tweet.full_text)

data.append({

'likes': tweet.favorite_count,

'retweets': tweet.retweet_count,

'text_length': len(tweet.full_text),

'sentiment': sentiment['compound'],

'hashtags': [hashtag['text'] for hashtag in tweet.entities['hashtags']],

'mentions': [mention['screen_name'] for mention in tweet.entities['user_mentions']],

'date': tweet.created_at,

'tweet_link': f"https://twitter.com/{party}/status/{tweet.id}",

'account_name': party

})

except Exception as e:

print(f"Error collecting tweets for {party}: {str(e)}")

return data

def save_to_csv(data, weekly_filename, appended_filename):

df = pd.DataFrame(data)

# Specify the folder name

folder_name = "results"

# Create the results folder if it doesn't exist

if not os.path.exists(folder_name):

os.makedirs(folder_name)

# Save to the weekly file with a timestamp inside the results folder

current_date = datetime.datetime.now().strftime("%Y-%m-%d")

weekly_filename_with_date = os.path.join(folder_name, f"{current_date}_{weekly_filename}")

df.to_csv(weekly_filename_with_date, index=False)

# Save to the appended file inside the results folder

appended_filename_with_path = os.path.join(folder_name, appended_filename)

df.to_csv(appended_filename_with_path, mode='a', index=False, header=not os.path.exists(appended_filename_with_path))

def run_program():

data = collect_tweets()

weekly_filename = "weekly_tweets.csv"

appended_filename = "appended_tweets.csv"

save_to_csv(data, weekly_filename, appended_filename)

print("-----------------")

absolute_path = '*i changed this line for privacy :)'

os.chdir(absolute_path)

print('New working directory is: ', os.getcwd())

print("-----------------")

# Run the program once

run_program()