python solution: refactor the test to get ready for testing projection
python solution: failing test for projection - missing method
use Pandas to parse and manipulate data