I have a folder that lives within a sharepoint drive url. I wish to automatically extract a certain file, df, within this folder and import this file using Python.
Desired Result:
To schedule a 'job' that imports this file, df, into python so that I can do some 'transformations' to it.
This is what I am doing:
import os
import schedule
import shutil
import time
import pandas
def job():
source_folder = r'https.sharepoint.com/sites/project/File.csv'
df = read_csv('source_folder')
for value in df:
....do some work...
schedule.every().day.at("20:00").do(job)
while 1:
schedule.run_pending()
time.sleep(1)
Any suggestions will be helpful