CSV python database

Question

I am trying to make it so I can compare what the user enters as name and space with what is already on the database. If it is there it doesn't enter the users name and space, but if it isn't there it does enter the users name and space on a new row. But I cant get it to work.

This is my code so far:

name = entry2.get() 
space = entry3.get()
file1 = open("database.csv", 'r')
lines = file1.read()
with open("database.csv", 'a+', newline='') as fp:
    if name or space in lines:
        print("No") 
    elif:
        writer = csv.writer(fp) 
        writer.writerow([name, '9:00am-10:00am', space])

Any help would be much appreciated.

Ana Maria Statie · Accepted Answer · 2021-01-14 15:10:35Z

1

Since you are dealing with a CSV file, I recommend using the Pandas library. With it, you can read the CSV file into a DataFrame which is pretty easy to manipulate.

import pandas as pd

file1_df = pd.read_csv('database.csv')
# if the columns in your csv are also called name and space
if name in file1_df.name or space in file1_df.space:
   print('No')
else:
   new_row = {'name': name, 'time': '9:00am-10:00am', 'space': space}
   file1_df = file1_df.append(new_row, ignore_index=True)
   file1_df.to_csv('database.csv', index=False)

edited Jan 14, 2021 at 15:10

answered Jan 14, 2021 at 15:02

Ana Maria Statie

114 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CSV python database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related