Skip to content

A simple GUI to a simple script that will count number of lines in all Excel files in a folder.

Notifications You must be signed in to change notification settings

laccore/srf_line_counter

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SRF Line Counter

Every year we have to report on the number of samples collected across all projects. Each project uses an Excel spreadsheet to track this where each row records a unique sample. This app uses pandas to open an Excel file, removes duplicates (because some rows have formulas so "empty rows" are not actually empty but are also not unique), and adds that to a running tally. It does this for every Excel file in a folder, with a user specified number of header rows being ignored.

About

A simple GUI to a simple script that will count number of lines in all Excel files in a folder.

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages