Skip to content

kyhokie/data_1_project

Repository files navigation

Tesla charge report analysis - September

This project is intended to provide a place to import, modify, and view data from TeslaFi data logger that is a CSV file.

The primary CSV for this project is "TeslaFi92022 (updates for project).csv".

This project was was created in Visual Studio Code V1.73.1
Required imports are:
-import pandas as pd
-import numpy as np
-import statistics


To prevent setcopywarning errors, it is recommended to run, at top level:
-<pd.options.mode.chained_assignment = None>


Feature of the product include:
Feature 1: Read Data in
Data read in from local CSV 'TeslaFi92022 (updates for project).csv'

Feature 2: Use built-in Pandas or Numpy functions to clean the data.
There are multiple cleanings of the data...
-FIRST Cleaning: Scrubbing of data to only show when vehicle state is 'online'
-SECOND Cleaning: Scrub to show when - Vehicle state is "Online"; Time to Full Charge == number; AND, Charger Actual Current == number
-THIRD Cleaning: We still have a lot of data. Use of dropna() to clear rows with null/NaN values to give us a nice workable dataset. This dataset was saved as the variable 'clean_Tesla'.

Feature 3: Analyze your data (five required)
-ONE: <len()> to detail number of occurrences
-TWO: <statistics.mode> to find the most common State of Charge Limit in the month of September
-THREE: <np.sum> to total the column "charge_miles_added_rated"
-FOUR: <np.median> we see the median mileage added per charge
-FIVE: <np.mean> applied to charge_limit_soc tell us the average charge limit set for the entire month
-SIX: divided battery range and maximum range columns from our dataframe and multiplied that result by 100 to give us the average percentage of max range used. These results have been added as an additional column titled "avg_percentage_used".
-SEVEN: <value_counts()> to see how many days of the month were captured; and, the number of reports for that day


Feature 4: Visualize your data (two required)
-PLOT 1: Available range when online, by date
-PLOT 2: Requested amperage for charge, by date
-PLOT 3: Total range added by requested charge percentage

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors