Skip to content

Have you accidentally added names to an .xlsx sheet and need to delete one matching specific criteria? Here's some logic that implements removing male names from a column. The script goes through your file, marks the rows where names matching the list are, prints the rows into terminal, deletes the rows and saves a new file without those rows.

Notifications You must be signed in to change notification settings

Jinssi/NameErase

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Have you accidentally added names to an .xlsx sheet and need to delete one matching specific criteria? Here's some logic that implements removing male names from a column. The script goes through your file, marks the rows where names matching the list are, prints the rows into terminal, deletes the rows and saves a new file without those rows.

Git clone to your pc Install pandas and openpyxl Save a copy of your original file in same folder with the script Edit the filename in the script to match yours Run the script with python ./malenames.py

About

Have you accidentally added names to an .xlsx sheet and need to delete one matching specific criteria? Here's some logic that implements removing male names from a column. The script goes through your file, marks the rows where names matching the list are, prints the rows into terminal, deletes the rows and saves a new file without those rows.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages