Ali's Photography Space…

Edit a Record

def edit_record(df):

clear() # To clear the terminal.

print(‘\n We are in a editing mode, for each column if you want to edit select ”y” if not select ”n”\n’)

# First we will fitch the columns from the df

col_list = []

for each in df.columns :

col_list.append(each)

print(df.to_string(index=False))

print(‘\n Select the id of the rescord you want to edit:’)

edit_id = input(‘ Enter the id : (c for cancel ) ‘)

if edit_id in [‘c’,’C’] :

input(‘ You select to cancel the editing… \n ** Press any key to continue .. . . ‘)

return

else:

for each in col_list:

if each !=’id’:

chose_edit= input(‘\n Do you want to change {} (y or n)’.format(each))

if chose_edit in [‘y’,’Y’]:

you_change = input(‘ Enter the new value: ‘)

df.loc[df[‘id’] == int(edit_id), [each]] = you_change

else:

input(‘\n You select not to change {} press Enter to change another column.’.format(each))

print(‘\n You finish Editing. .. \n ‘)

input(‘\n\n\n\n ** Press any key to continue .. . . ‘)

Delete a Record

def delete_record(df1):

clear()

print(‘\n’,df1.to_string(index=False))

del_record = input(‘\n Enter the ”ID” for the record you want to delete: ‘)

#Delete the row with id = del_record 

df1 = df1[df1.id != int(del_record)]

print(‘\n Record been deleted … .. \n ‘)

global df # Reset the df as global variable

df = df1

input(‘\n\n\n\n ** Press any key to continue .. . . ‘)