How to remove row from excel using Python/PySimpleGUI

Question

Dears,

How to remove row from excel using Python/PySimpleGUI. Knowing that I'm using the reverse process of adding rows to excel file using PySimple :

Add Row :

import PySimpleGUI as sg import pandas as pd .......... [sg.Button('Submit', size=(6, 1), button_color=('White','Dark'))] if event == 'Submit': new_record = pd.DataFrame(values, index=[0]) df = pd.concat([df, new_record], ignore_index=True) df.to_excel(EXCEL_FILE, index=False) sg.popup('Data Saved!', font=("Helvetica", 11),text_color='Yellow', no_titlebar=True, button_type=5) clear_input()

And for deleting row with a given key , i'm using the following code and didn't help :

 if event == 'Delete': df = pd.read_excel(EXCEL_FILE) df = df[df.Column1!= 'ENTRY'] df.to_excel(EXCEL_FILE, index=False) sg.popup('Entry Deleted!')

Could you please advice ? Thanks

Virt · Accepted Answer · 2022-11-06 22:09:00Z

1

Could you drop the column from the df and then rewrite to excel if needed?

df = df.drop(['rowToDelete'])

answered Nov 6, 2022 at 22:09

Virt

134 bronze badges

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

4 Comments

PyiPath2022 Over a year ago

Thanks @Virt, I add your recommendation, unfortunately didn't help, I got the following error : df = df.drop[df.Column1!='ENTRY'] ~~~~~~~^^^^^^^^^^^^^^^^^^ TypeError: 'method' object is not subscriptable

PyiPath2022 Over a year ago

Hi again, just to clarify little bit more, I'm using the following topic : youtube.com/watch?v=svcv8uub0D0 , to create an excel form using python, and since the program is creating duplicate enteries with same value in 1st column and not checking what is inside, so I want to find a way to check if this entery is already exists, than I will delete it ( in case I want to change data inside ) or use another method for updating same entery instead of creating a duplicate one. Hope you got my point . Thx

PyiPath2022 Over a year ago

@Jason Yang, Could you please help on this topic? Thanks in advance

PyiPath2022 Over a year ago

Anyone can help on this topic?

Collectives™ on Stack Overflow

How to remove row from excel using Python/PySimpleGUI

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related