Ze1598

#from pandas_datareader import data as web

def download_data(tickers, start_date, end_date):
    for ticker in tickers:
        try:
            print(f'Downloading {ticker}')
            # Download data from Yahoo
            temp_df = web.DataReader(ticker, 'yahoo', start_date, end_date)
            # Create a column with only the ticker symbol
            temp_df["Ticker"] = ticker

Ze1598

import pygame
from random import randint, choice

# RGB colours
BLACK = (0, 0,0)
WHITE = (255, 255, 255)
GREEN = (44, 205, 23)
RED = (216, 10, 0)
BLUE = (27, 64, 255)
PURPLE = (121, 0, 234)

Ze1598

import pandas as pd
import openpyxl as pxl
from openpyxl.utils.dataframe import dataframe_to_rows

# Name of the workbook we'll be using
filename = 'test_wb.xlsx'

# For demo purposes, create a new 1-sheet workbook
# DataFrame to be inserted in the first worksheet
firstMockDF = pd.DataFrame({

Ze1598

# Imports
# (...)

# selenium set up
# (...)

# scrape dictionary of characters and output as pickle
# (...)

# Running dataframe to collect operator data into

Ze1598

# Imports
# (...)

# selenium set up
# (...)

# scrape dictionary of characters and output as pickle
# (...)

# op_dict is the dictionary with all characters and their URLs

Ze1598

import requests
import pickle
from bs4 import BeautifulSoup

req = requests.get("https://gamepress.gg/arknights/tools/interactive-operator-list")
soup = BeautifulSoup(req.content, "lxml")

# Get all the table cells (<td>) with information about the operators
op_list = soup.find_all("td", class_="operator-cell")
op_dict = {}

Ze1598

# imports, driver variable set up and loading a character page
# (...)

def get_stats_per_level(num_levels):
    
    for i in range(num_levels):
        # Code to read stats (see previous code snippet)
        # (...)
        
        # Get the arrow to increase operator level

Ze1598

# imports, driver variable set up and loading a character page
# (...)

# First thing we need before reading data: decrease the operator level (even if it is already at the lowest level possible)
# Otherwise some stats may be missing
decrease_level_button = driver.find_element_by_class_name("fa-arrow-left")
decrease_level_button.click()

# Read the opreator class
operator_class = driver.find_element_by_class_name("profession-title").text.strip()

Ze1598

from selenium import webdriver
from webdriver_manager.chrome import ChromeDriverManager

# Dynamically install a Chrome web driver and instantiate it
driver = webdriver.Chrome(ChromeDriverManager().install())
# Make the driver wait 7 seconds for the page to load
driver.implicitly_wait(7)
# Go the Phantom's character page
driver.get("https://gamepress.gg/arknights/operator/phantom")
# Element to scroll to

Ze1598

import pandas as pd

# Working data
data = [
    {
        "Symbol": "KLAC",
        "Company": "KLA Corporation",
        "Sector": "Information Technology",
        "Date": "2018-02-02",
        "Price": 99.11979699999999,