pmartinez8241

{
    "Ahsoka": {
        "name": "Ahsoka",
        "id": 114461,
        "show_url": "https://api.themoviedb.org/3/tv/114461",
        "seasons": {
            "Specials": {
                "season_name": "Specials",
                "season_number": 0,
                "episode_count": 4,

pmartinez8241

{
    "Ahsoka": {
        "name": "Ahsoka",
        "base_url": "Z:\\Entertainment\\Media\\TV Shows",
        "url": "Z:\\Entertainment\\Media\\TV Shows\\Ahsoka",
        "seasons": {
            "Season 01": {
                "season_name": "Season 01",
                "season_url": "Z:\\Entertainment\\Media\\TV Shows\\Ahsoka\\Season 01",
                "episodes": [

pmartinez8241

---
title: "google_analytics_cyclistic_case_study"
author: "Pete Martinez"
date: "2024-08-07"
output: 
  html_document:
    toc: true
    theme: united
---

pmartinez8241

library(tidyverse)
library(dplyr)
library(tibble)
library(janitor)
library("lubridate")
library(here)
library(skimr)
library(ggplot2)

#READ CSV FILES

pmartinez8241

local_tv_location <- "T:\\Media\\TV Shows"
network_tv_location <- r"{Z:\Entertainment\Media\TV Shows/}"


#*************  ROOT COUNT ******************
root_local = list()
root_network = list()
root_local_dir = list.dirs(local_tv_location)
for(x in root_local_dir)
{

pmartinez8241

use gtk::{prelude::*, Orientation};
use gtk::{glib, Application, ApplicationWindow, Widget};
use std::fs;

const APP_ID: &str = "org.gtk_rs.HelloWorld2";

fn main() -> glib::ExitCode {
    // Create a new application
    let app = Application::builder().application_id(APP_ID).build();
    // Connect to "activate" signal of `app`

pmartinez8241

INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e01 - Currahee.mkv');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e01 - Currahee.srt');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e02 - Day of Days.mkv');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e02 - Day of Days.srt');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e03 - Carentan.mkv');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e03 - Carentan.srt');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e04 - Replacements.mkv');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e04 - Replacements.srt');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e05 - Crossroads.mkv');
INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e05 - Crossroads.srt');

pmartinez8241

import psycopg2
import json




def get_drives_and_media_type():
    results = []
    with psycopg2.connect("host=# dbname=entertainment_database user=# password=#") as conn:
        with conn.cursor() as db_cursor: