u/aggiefury101 - full

import csv
import json
import time
import os
import pandas as pd
from selenium import webdriver

# Load Chrome Driver
CHROMEDRIVER_PATH = 'C:/Users/rgraham_adm/Desktop/WebScraper2020/chromedriver.exe'

# ------ changes ------
# Names to Be Renamed - This is referenced in the renaming loop
newNames = 'C:/Users/rgraham_adm/Desktop/RedditScript/Forms/NewNames.csv'

with open('newNames', 'r') as f:
    reader = csv.reader(f)
    newNameList = list(reader)
# ------ /changes ------

appState = {
    "recentDestinations": [
        {
            "id": "Save as PDF",
            "origin": "local",
            "account": ""
        }
    ],
    "selectedDestinationId": "Save as PDF",
    "version": 2
}

downloadPath = 'C:/Users/rgraham_adm/Desktop/RedditScript/Forms'

profile = {'printing.print_preview_sticky_settings.appState': json.dumps(appState),
           'savefile.default_directory': downloadPath}

options = webdriver.ChromeOptions()
options.add_experimental_option('prefs', profile)
options.add_argument('--kiosk-printing')
driver = webdriver.Chrome(CHROMEDRIVER_PATH, chrome_options=options)
with open('C:/Users/rgraham_adm/Desktop/RedditScript/Test.csv') as example_file:
    example_reader = csv.reader(example_file)
    for row in example_reader:
        driver.get(row[0]), time.sleep(5), driver.execute_script('window.print();')

driver.quit()

# ------ changes ------
for index, item in enumerate(os.listdir(downloadPath):
    """Assuming that the CSV with your new file names:
    a. is in the correct order / doesn't require an order,
    b. contains a column with the new file names in string format, without file extensions
    this should work. The second item in the rename method uses the following syntax
    to determine the new filename:

    newNames - [index] - [0]
    name of the filepath variable - number of the file to find the corresponding line - number of the column containing the string
    """
    os.rename(f'{downloadPath}/{item}', f'{downloadPath}/{newNames[index][0]}.pdf')