CODE IN PYTHON PLEASE
The objective is to create a code in Python that can extract the columns highlighted in blue (Column T and AB3) and output them to a .txt file. The code should be able to generate the text file with the columns that are highlighted in blue and store them on a separate folder. Below shows how the Test.xlsm file looks like as well as how the text file should look like when the code extracts and outputs it.
Google drive to access Test.xlsm file: https://drive.google.com/drive/folders/16utzb5_h7yMCN8_13E_JqasfcpykZOYr?usp=sharing
What my code outputs is shown in the picture (O1.png)
What I would like for my code to output is the columns next to each other (Right Example.png)
The current code is able to output Columns T and AB3 but I am not able to output them next to each other as shown above. We would also like for the code to be capable of storing the text file to a separate folder. Below is the code I have been working on.
#package to read xlsm file import openpyxl #give full path to excel file here path = "Test.xlsm" #loading the excel sheet wb_obj = openpyxl.load_workbook(path) #lading the required sheet by name from excel sheet_obj = wb_obj["Correct-L"] #opening text file to write data. f = open("Correct_l.txt","w") #getting max number of rows sheet has, so we can loop through all rows num_row = sheet_obj.max_row #writing the first line to text file f.writelines("Band Group Number Time\n") #for loop to get data from first blue column #and saving every value that is not None to text file for i in range(3,num_row+1): cell_obj = sheet_obj.cell(row=i, column=20) if str(cell_obj.value) != "None": f.writelines(str(cell_obj.value)+"\n") f.writelines("Band Group Number Time\n") #for loop to get data from second blue column #and saving every value that is not None to text file for i in range(3,num_row+1): cell_obj = sheet_obj.cell(row=i, column=28) if str(cell_obj.value) != "None": f.writelines(str(cell_obj.value) + "\n")
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 3 images
- Assessment Description Honors Students: Complete this assignment according to the directions provided in the "Honors Addendum," located in Class Resources. This activity has multiple parts. All parts must be completed prior to documentation submission. Part 1: Reading and Writing Text Files. In this activity, you will learn how to read and write text files using non buffered and buffered File I/O classes, then learn how to parse a String into tokens using the String split() method, and finally, how to handle exceptions using various approaches. Part 2: Reading and Writing JSON Files. In this activity, you will learn how to read, write, and serialize JSON files to and from Java Objects. Refer to the instructions within "Activity 4 Guide" to complete the assignment. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful…arrow_forwardCode in C language. Please provide code for 3 different files. One header file and two .C files. I need the code for each file. Please provide photos of the output and source code for each file (3). Please follow All instructions in the photo provided. Use the provided input.txt file provided below. A1, A2 20294 Lorenzana Dr Woodland Hills, CA 91364 B1, B2 19831 Henshaw St Culver City, CA 94023 C1, C2 5142 Dumont Pl Azusa, CA 91112 D1, D2 20636 De Forest St Woodland Hills, CA 91364 A1, A2 20294 Lorenzana Dr Woodland Hills, CA 91364 E1, E2 4851 Poe Ave Woodland Hills, CA 91364 F1, F2 20225 Lorenzana Dr Los Angeles, CA 91111 G1, G2 20253 Lorenzana Dr Los Angeles, CA 90005 H1, H2 5241 Del Moreno Dr Los Angeles, CA 91110 I1, I2 5332 Felice Pl Stevenson Ranch, CA 94135 J1, J2 5135 Quakertown Ave Thousand Oaks, CA 91362 K1, K2 720 Eucalyptus Ave 105 Inglewood, CA 89030 L1, L2 5021 Dumont Pl Woodland Hills, CA 91364 M1, M2 4819 Quedo Pl Westlake Village, CA 91362 I1, I2 5332 Felice Pl…arrow_forwardFiles Class Activity Write a program to write your first name (hard coded) to the screen and possibly to a file whose name is passed into the program from the command line. It can be written in upper or lower case or mixed case as the default. Usage: writer [-f filename] If the -f option is included with a filename, then create a file with that name or overwrite a previously existing file and write your name in on the first line. If the -f option is not included, then only write your name to the screen followed by a newline. Use a copy of the original getopt to parse the command line. Be sure to test whether a file open succeeds or not and close any file you open when done.arrow_forward
- Pls help ASAParrow_forwardFile redirection allows you to redirect standard input (keyboard) and instead read from a file specified at the command prompt. It requires the use of the < operator (e.g. java MyProgram < input_file.txt) True or Falsearrow_forwardWhen generating a test executable using cmake, header files are required in the ADD_EXECUTABLE() functions in a CMakeLists.txt file. True Falsearrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education