search

merrecdarkin / Wil-Project-AEMO-CSV-Efficient-Reading-Sorting-and-Export-

WIL
MIT License
1 stars 0 forks source link

Added duplication purge and column sort #11

Closed larryhuangdev closed 2 years ago

larryhuangdev commented 2 years ago

Just small PR to add extra features:

  1. https://github.com/merrecdarkin/Wil-Project-AEMO-CSV-Efficient-Reading-Sorting-and-Export-/commit/65690bbe46027ba37645c5e975573c3455e87d8b Added drop_duplicates() in bidperoffer table to purge quantity data duplication. Thanks @merrecdarkin
  2. https://github.com/merrecdarkin/Wil-Project-AEMO-CSV-Efficient-Reading-Sorting-and-Export-/commit/211094b2b6b23d39bf12d9db5641f973264b0bee Added sort_by() to sort column by DUID and SETTLEMENTDATE
  3. https://github.com/merrecdarkin/Wil-Project-AEMO-CSV-Efficient-Reading-Sorting-and-Export-/commit/d2d9eb5b14385785ca43dd0eaa6a59d0a7b2c071 Added some code to calculate the process runtime (from when the Export button is clicked till the Excel file has been exported) and print to console