Question

Timetable Extractor using Python

1. Create a simple database and table structure (0NF) for timetable schedule in SQLite

2. Create a Python function (def) to:

a. read all timetables in Microsoft Excel format

b. extract the timetable contents

c. store the contents into the created table (in item #1)

3. Illustrate a flowchart for the overall task workflow

Chat started

Answer 1

import pandas as pd


def main():
    # 2
    data = pd.read_csv('file.csv', delimiter=',')
    # 1
    timetable = pd.DataTable(data)
    
    for line in timetable:
        print(line)
        
if __name__ == '__main__':
    main()