How to update csv Python database?

Question

Python

There is a database that is updated every hour, how to update the csv file? for example through schedule or restart.

import json
from bot.bot import Bot
from bot.handler import MessageHandler, BotButtonCommandHandler, Filter
import pandas as pd
TOKEN = "....."
bot = Bot(token=TOKEN)

cases=pd.read_csv('cases.csv',sep=",",index_col='Country/Other')

def buttons_answer_cb(bot, event) :
  
def message_stat(bot, event) :
    message = event.text

    if message=="Испания":
        id = 'Spain'
   
        message_cb(bot,event)
    bot.send_text(chat_id=event.data['chat']['chatId'],
                  text=f"Данные по стране: ({cases.loc[id, 'New Cases']})"
                     
bot.dispatcher.add_handler(MessageHandler(callback=message_stat))
bot.dispatcher.add_handler(MessageHandler(filters=Filter.regexp("/start*"), callback=message_cb))
bot.dispatcher.add_handler(BotButtonCommandHandler(callback=buttons_answer_cb))

bot.start_polling()
bot.idle()

Answer 1

opened
rewritten
closed