Insert ROW-WISE Values into DaTaFrAmE using PYTHON

This article will help you to insert ROW-WISE values into the data frame by calling functions.

SCENARIO:

Jhon has to create a .csv file containing dummy data for multiple-choice questions. So that he can upload it into the EXAM system. Unfortunately, such data files are not available online. So he thought of creating a customized file for himself.

NOTE: If you are only here to see how row-wise data is entered by using a loop. JUMP!! to the code.

Copyright

STEPS:

Create functions for test data

Create Dataframe with column names

Enter ROW-WISE data into the data frame by calling functions

Create a .csv file

Let’s Get Started

This is the complete code. I hope it will help you. Thank you!!

import pandas as pd
from random import random
from numpy import random

Create Functions for Test Data

def sub():
    name = "Biology"
    return name

Create a list containing place holder text: I have entered 7 and picking random values for the answer options

def opt():
    options = ['Pharetra magna quisque cubilia tellus dictumst luctus lectus quisque platea.',
               'Praesent, tristique convallis integer litora parturient viverra placerat conubia nisi.',
               'Tortor ut scelerisque nulla sagittis ipsum hendrerit rutrum ultrices consequat.',
               'Risus. Amet nam, magnis penatibus pulvinar. Ut curae;. Senectus hac.',
               'Pede justo malesuada sollicitudin suspendisse massa.',
               'Metus Suspendisse parturient elit.',
               'Posuere ridiculus nullam varius facilisis proin nam cursus conubia ante.']

    return random.choice(options)

Create Questions on the same lines as explained above

def que():
    options = [
        'Morbi vivamus fusce blandit. Duis habitasse curabitur. Venenatis nisi suscipit euismod vestibulum sit faucibus potenti sociis dui lectus cursus velit. Posuere nisl ad lacus faucibus blandit quisque natoque et tempor.',
        'Magna, urna. Magna lacus lectus proin eleifend inceptos sapien bibendum vulputate. Augue magnis sapien dapibus, luctus, natoque dis mi a massa etiam. Mauris placerat ut nisi sapien laoreet dictumst vivamus.',
        'Hac consequat. Luctus praesent aliquet nullam laoreet ultricies varius At duis. Praesent duis montes scelerisque, hymenaeos semper et suspendisse pharetra sit libero cum torquent ipsum penatibus sociosqu nunc. Inceptos nec.',
        'Sociis platea ultrices platea sit eleifend cubilia ullamcorper aliquet eros senectus, lacus class phasellus. Parturient nullam elit tempor natoque eleifend. Et vestibulum semper id scelerisque nostra conubia ad pede eros.',
        'Platea. Sollicitudin vehicula. Tellus aliquam mollis porta proin curabitur. Per diam consectetuer. Nec, mus venenatis. Sapien potenti aliquam dapibus, leo egestas. Tristique et lectus, suspendisse non blandit semper. Volutpat mauris.',
        'Aliquet, vivamus habitant conubia dui hac semper, cursus. Rutrum placerat tristique convallis sociosqu nonummy nibh eu faucibus per. Ultricies conubia dapibus aliquam sollicitudin lacus velit libero felis Penatibus magnis, pulvinar.',
        'Nec odio ullamcorper dapibus Netus lectus, at potenti vehicula pretium sem conubia tincidunt ullamcorper. Ante venenatis, ante curabitur habitasse. Curabitur. Arcu mattis id, gravida quisque, molestie viverra rutrum volutpat tempus.',
        'Pretium dictumst convallis facilisi etiam tortor netus tristique. Facilisis varius ligula urna vel commodo natoque. Vulputate eget porttitor ridiculus maecenas sociis. Ultrices vulputate commodo hendrerit faucibus iaculis non lacinia augue.']

    return random.choice(options)


Create an empty dataframe
df = pd.DataFrame(columns=[''])
print(df)

Insert the values ROW-WISE into the data frame

for i in range(1000):
    # inserting values in  rows by calling functions
    df.loc[i, 'Subject'] = sub()
    # concatenate question with the loop number
    df.loc[i, 'Question'] = str (i) + " : " + que ()
    df.loc[i, 'Option 1'] = opt ()
    df.loc[i, 'Option 2'] = opt ()
    df.loc[i, 'Option 3'] = opt ()
    df.loc[i, 'Option 4'] = opt ()

Create a csv file

df.to_csv('MCQ.csv')