Range ( "D15" ) print ( "Question 1B" ) print ( "OEN1:", oe1, "- JUSTIF:", ju1 ) print ( "OEN2:", oe2, "- JUSTIF:", ju2 ) print () # Close the file without saving Worksheets ( "1ayb_MisiónyVisiónFutura" ). Range ( "C7" ) print ( "Question 1A" ) print ( "Mission:", mission ) print ( "Vision:", vision ) print () # Get the answers to the Q1B and write them into the summary file Open ( file ) # Get the answers to the Q1A and write them into the summary file stdout = bk # Select a file and open itįile = "path_of_file" wb_data = excel. open ( "Answers_Report.txt", mode = "w", encoding = "utf-8" ) sys. Visible = True # Redirect the stdout to a file Import win32com.client import sys, io # Open up Excel and make it visible (actually you don't need to make it visible)Įxcel = win32com. If not, you can easilly install it using pip: Getting startedįirst, be sure that you have pywin32 installed in your computer. With the use of this technology, pywin32 allows us to interact with COM objects and do almost anything that a Microsoft Application can do with some Python code. COM is the foundation technology for Microsoft’s OLE (compound documents), ActiveX (Internet-enabled components), as well as others that allows us to control Windows applications from another program. The Microsoft Component Object Model (COM) is a platform-independent, distributed, object-oriented system for creating binary software components that can interact. With this package, you can easily access Window’s Component Object Model (COM) and control Microsoft applications via Python. However, there is another option to work directly with the functionalites of Windows OS programs called “Python for Windows Extensions” also known as pywin32. Python has many options for working with Excel files (pandas, openpyxL, xlsxwriter, etc). In order to reduce all this process of grading files, I decided that I’ll use Python to extract all the information into a little report and with the help of another Excel file I’ll put the grades back in each of the student’s files. However, grading these files is really a hassle because you have to open one by one, adjust the zoom level and the size of the cells for a proper reading (even some students use LibreOffice and when you open the files in Excel the format goes all wonky). There, to evaluate the students, we give them a business scenario and an Excel file with a set of questions in a predefined template. Please don't cut articles from FT.com and redistribute by email or post to the web.Besides my regular job, I’m also a teaching assistant at the strategic planning course in my university. Illustrations by Maria Raymondsdotter Copyright The Financial Times Limited 2017. We have marked these activities as “sometimes”, and have not included them in the overall count of activities that can be technically automated. Since some activities require different capabilities depending on the context of the occupation, this means some job groups contain activities that can technically be automated for some occupations but not others in the same group.įor example, for the “Forest, Conservation, and Logging Workers” group, the activity of “Inspect equipment or facilities to determine condition or maintenance needs” can technically be automated for logging equipment operators, but not for forest and conservation loggers. An activity is considered technically automatable only if the answer is yes for all of the capabilities required to do that activity.įor ease of navigation, we have grouped the 820 occupations into 97 job groups, under 23 job categories. They also assessed whether existing automation technology could achieve the same level of performance. McKinsey then considered what level of performance of that capability is required, based on how humans currently perform those activities. Greeting customers requires capabilities such as ‘sensory perception’, ‘social and emotional sensing’, and ‘natural language generation’. McKinsey then assessed, for each activity, what combination of 18 different performance capabilities were required to do that activity.įor example, the job of retail salesperson is made up of activities such as ‘Greet customer’, ‘Demonstrate product features’ etc. There are around 2,000 unique activities. McKinsey’s team, using US Bureau of Labor Statistics data, deconstructed 820 occupations into their constituent work activities. Just because an activity could technically be automated does not mean that someone has made a product or solution to do so. It tells you only whether an activity could technically be automated using technology that is currently available. This interactive calculator was made using data provided to the Financial Times by the McKinsey Global Institute.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |