Skip to content

labeeb987/etl_homework

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Task

  1. Fork this project
  2. Create a python script that reads all of the rows from homework.csv and outputs them to a new file formatted.csv using the headers from example.csv as a guideline. (See Transformations below for more details.)
  3. You may you any libraries you wish, but you must include a requirements.txt if you import anything outside of the standard library.
  4. There is no time limit for this assignment.
  5. You may ask any clarifying questions via email.
  6. Create a pull request against this repository with an English description of how your code works when you are complete

Transformations

Follow industry standards for each data type when decided on the final format for cells.

  • Dates should use ISO 8601
  • Currency should be rounded to unit of accounting. Assume USD for currency and round to cents.
  • For dimensions without units, assume inches. Convert anything which isn't in inches to inches.
  • For weights without units, assume pounds. Convert anything which isn't in pounds to pounds.
  • UPC / Gtin / EAN should be handled as strings
  • Floating point and decimal numbers should preserve as much precision as possible

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages

  • Python 100.0%