Python scripting

Produce an optimised series of scripts to perform specific functions. The scripts need to be fully annotated with comments. The scripts should be written in python 3. The series of scripts will be functions in a library so should be short. Each script once confirmed will need to be transformed into an Object. We will also need a list of the dependent packages that are loaded in the different scripts and entered into a ‘[login to view URL]’ file. Script 1: 1. Receive a file path for a csv. 2. Load the csv into the script. 3. Return the loaded file as an array. Script 2: 1. Receive an array. 2. Reshape a large 2D array (with 100+ columns) to simple array with 2 columns. 3. Return the reshaped simple array. Script 3: 1. Load an array (called ‘working’) 2. Load an array (called ‘reference’) 3. Loop through ‘working’ array for each row to check if it matches an ID in the ‘reference’ array. If it does inset the row into the ‘output’ array. 4. Return output array. Script 4: 1. Get array. 2. Create sql database table. 3. Insert array into table. Script 5: 1. Received a folder path 2. Get a list of files in a folder which have a specific file extension. 3. Return the list of files as an array. Example files will be provided to the developer. This is the start of a large number of scripts.