Twitter bot to post tweets based on existing csv DataEducation.bot

data.csv

DatoEducacion.py

#!/usr/bin/python2.7
# -*- coding: utf-8 -*-

#Load required modules
import twitter
import csv
from datetime import datetime
#from time import sleep
import time
from dateutil.relativedelta import relativedelta
import schedule

# Twitter API configuration
config={}
execfile("TweetConfig.py", config)

# Twitter API authentication
api = twitter.Api(consumer_key=config['consumer_key'], consumer_secret=config['consumer_secret'], access_token_key=config['access_key'], access_token_secret=config['access_secret'])

# Tweet expense when correct time
def tweetExpense():
    # Open data file
    filename = "data.csv"
    with open(filename, 'r') as csvfile:
        spamreader = csv.DictReader(csvfile)
        # csv rows loop
        for row in spamreader:
						zona = row['zona']
						provincia = row['provincia']
						perc_bec_comedor_pub = row['perc_bec_comedor_pub']
						perc_bec_comedor_priv = row['perc_bec_comedor_priv']
						status_text = 'En la zona escolar de ' + zona + ' (' + provincia + ') hay ' + perc_bec_comedor_pub + '% de alumnado becado para comedor en la escuela pública vs ' + perc_bec_comedor_priv + '% en la concertada-privada. EAJ-PNV, PSE-EE y PPVasco no impidáis que se debata en Parlamento. Aceptad a trámite la ILP_EInklusiboa el jueves'

						print (len(status_text))
						status = api.PostUpdate(status_text.decode("utf-8"))
						time.sleep(303)
						print(status_text)

# Schedule tweetExpense every minute
schedule.every(1).minutes.do(tweetExpense)

while True:
    schedule.run_pending()
    time.sleep(15)

TweetConfig.py

#--------------------------------------------------------------------------------
# These tokens are needed for user authentication.
# Credentials can be generates via Twitter's Application Management:
#	https://apps.twitter.com/app/new
#
# This file must be renamed as TweetConfig.py
# to make the script works
#--------------------------------------------------------------------------------

consumer_key = ""
consumer_secret = ""
access_key = ""
access_secret = ""