Python for Project Managers

UNDER CONSTRUCTION. WILL HOPEFULLY BE RUNNING SOON

Sat 15 April 2017

Extracting MS Project Tasks into an Pandas Dataframe

Posted by Eric Garlic in MS Project   

UseCase

The class must be able to "flatten" an MS Project file task into a Pandas DataFrame ready for further manipulation. Later posts will take this DataFrame of tasks, export excel workbooks of selected task for user to update and then process these changes back into the original MS Project file.

Approach

Applications & Python Modules Used:

  • Microsoft Project
  • Python Pywin32, Pandas

The Solution

PyWin32

MS Project Object Model

Comments