text2csv.py

import os
import pandas as pd
import numpy as np
def txt_to_csv(path): 
  """
  The csv Generarted will be such:
    |Questions | Correct | A | B | C | D |
  0 |  myQ     |    X    | a | X | c | d |  
  """   
  questions=[]
  key=[]
  dist1=[]
  dist2=[]
  dist3=[]
  dist4=[]
  with open(path, errors='ignore',mode="r") as file1:
      files = file1.readlines()
      i=0
      for i in range(len(files)):
        if files[i][0]=='\n':
          try:
            if files[i+1][3]=='#':
              continue          
            questions.append(files[i+1][3:len(files)-1])
            key.append(files[i+2][2:len(files[i+2])-1])
            if (files[i+3]!="\n"):
              dist1.append(files[i+3][2:len(files[i+3])-1])
            else:
              dist1.append(np.nan)
              dist2.append(np.nan)
              dist3.append(np.nan)
              dist4.append(np.nan)
              continue
            if (files[i+4]!="\n"):
              dist2.append(files[i+4][2:len(files[i+4])-1])
            else:
              dist2.append(np.nan)
              dist3.append(np.nan)
              dist4.append(np.nan)
              continue
            if (files[i+5]!="\n"):
              dist3.append(files[i+5][2:len(files[i+5])-1])
            else:
              dist3.append(np.nan)
              dist4.append(np.nan)
              continue
            if (files[i+6]!="\n"):
              dist4.append(files[i+6][2:len(files[i+6])-1])
            else:
              dist4.append(np.nan)
          except:
            pass
  bank={}
  bank["Questions"]=questions
  bank["Correct"]=key
  bank["A"]=dist1
  bank["B"]=dist2
  bank["C"]=dist3
  bank["D"]=dist4
  df=pd.DataFrame(bank)
  return df

def parse_files(sourcePath='/content/drive/MyDrive/Colab Notebooks/Data_trivial/',destination='/content/drive/MyDrive/Colab Notebooks/Data_trivial_csv/'):
  """
  Input SourcePath and Destination Path to trverse through the files and convert them into csv
  Requirement Python 3.x , Numpy , os , Pandas
  or run this in Google Colab as it is
  """
  filenames=sourcePath
  for files in os.listdir(filenames):
     path=filenames+files
     data=txt_to_csv(path)
     data.to_csv(destination+files+'.csv')

print(' Input SourcePath and Destination Path to trverse through the files and convert them into csv \n  Requirement Python 3.x , Numpy , os , Pandas \n  or run this in Google Colab as it is')
parse_files(sourcePath=input('SourcePath'),destination=input('Destination Path'))