ent_csv_creation.py

#importing required modules
import pandas as pd
import numpy as np

#function to create or check required files
def create_file():
    try:
        exp = pd.read_csv('ent_expense.csv')
    except FileNotFoundError:
        exp = pd.DataFrame({'Purchase': np.NaN,'Electricity': np.NaN,'Telecom': np.NaN,'Rent': np.NaN,'Interest': np.NaN,'Salary/Wages': np.NaN,'Maintenance': np.NaN,'Tax': np.NaN,'Advertisement': np.NaN,'Insurance': np.NaN,'Other': np.NaN}, index=["Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec", "Jan","Feb","Mar"])
        exp.to_csv('ent_expense.csv')

    try:
        inc = pd.read_csv('ent_income.csv')
    except FileNotFoundError:
        inc = pd.DataFrame({'Sales': np.NaN,'Interest_inc': np.NaN,'Rent_inc': np.NaN,'Bad_Debts_Recovered': np.NaN,'Commission': np.NaN,'Other_inc': np.NaN}, index=["Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar"])
        inc.to_csv("ent_income.csv")

#if this file is run as main, run this function.
if __name__ == '__main__':
    create_file()