ryanorsinger

ryanorsinger

id,customer_id,gender,is_senior_citizen,partner,dependents,phone_service,internet_service,contract_int,payment_type,monthly_charges,total_charges,churn,tenure_month,has_churned,has_phone,has_internet,has_internet_and_phone,partner_dependents,start_day,phone_type,internet_type,contract_type
0,0002-ORFBO,Female,0,Yes,Yes,1,1,1,Mailed check,65.6,593.3,No,9.0,False,True,True,True,3,2020-05-03,One Line,DSL,1 Year
1,0003-MKNFE,Male,0,No,No,2,1,0,Mailed check,59.9,542.4,No,9.1,False,True,True,True,0,2020-05-03,Two or More Lines,DSL,Month-to-Month
2,0004-TLHLJ,Male,0,No,No,1,2,0,Electronic check,73.9,280.85,Yes,3.8,True,True,True,True,0,2020-11-03,One Line,Fiber Optic,Month-to-Month
3,0011-IGKFF,Male,1,Yes,No,1,2,0,Electronic check,98.0,1237.85,Yes,12.6,True,True,True,True,1,2020-02-03,One Line,Fiber Optic,Month-to-Month
4,0013-EXCHZ,Female,1,Yes,No,1,2,0,Mailed check,83.9,267.4,Yes,3.2,True,True,True,True,1,2020-11-03,One Line,Fiber Optic,Month-to-Month
5,0013-MHZWF,Female,0,No,Yes,1,1,0,Credit card (automatic),69.4

ryanorsinger

MacOS:

• $ brew services stop mysql

• $ brew services list

• $ brew uninstall mysql

• $ brew install mysql

• $ brew postinstall mysql

If Any error found then run those cmd

• $ sudo rm -rf /usr/local/var/mysql

ryanorsinger

Installing Homebrew and Anaconda on a Mac

Install Homebrew

Run the following command on your terminal to install Homebrew. Homebrew is a package manager for Macs and is used to install useful development tools and software.

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

Install Anaconda through Homebrew

1. Run brew install --cask anaconda to install Anaconda

ryanorsinger

drinks = [
    {
        "type": "water",
        "calories": 0,
        "number_consumed": 5
    },
    {
        "type": "orange juice",
        "calories": 220,

ryanorsinger

Python String, List, Dictionary Warmup Exercises

Write the code that operates on a single string containing the make and model of a vehicle. The first part of the string before the space is the make The last part of the string after the space is the model We can assume that the strings will only have one space. Assume the input string is completely lower-cased.

Example inputs:

ryanorsinger

# Prompt the user to enter a number until they enter 5
while True:
    
    # Obtain user input
    number = input("Please input the number 5: ")

    # Check if the input string is a digit
    if number.isdigit():

        # Now that we know the input is a digit, we can make sure to turn that string containing the number into an integer.

ryanorsinger

def is_prime(num):
    """
    Returns a boolean if the input argument is a prime number or not.
    """
    if type(num) != int:
        return False
    if num <= 0:
        return False
    if num == 1:
        return True

ryanorsinger

# Following up on https://github.com/mwaskom/seaborn/issues/1027 and https://stackoverflow.com/questions/34615854/seaborn-countplot-with-normalized-y-axis-per-group

import pandas as pd
import seaborn as sns

def category_percentages_by_another_category(df, category_a, category_b):
    (df.groupby(category_b)[category_a].value_counts(normalize=True)
    .rename('percent')
    .reset_index()
    .pipe((sns.catplot, 'data'), x=category_a, y='percent', hue=category_b, kind='bar'))

ryanorsinger

import pandas as pd
from sklearn.model_selection import train_test_split

def split_stratify(df, target, bins=5):
    """
    This function takes in a dataframe, the string of the target variable name, and the number of bins
    This function makes bins out of the continuous target then stratifies the splits by the bins
    Finally, the function returns train, validate, and test, and the binned column is removed
    The current failure state of this function comes if there are bins with only one observation.
    """