<jupyter_start><jupyter_text>Assignment for Week 1      Purpose:      This assignment is intended to help you do the following:       1.	Open a GitHub account for your own use and for your career advancement (if you already do not have one).     2.	Submit information and code in GitHub following best practices from the Udacity course.     3.	Explore a dataset thoroughly.      4.	Find and print descriptive information from the dataset.<jupyter_code># Load the dataset using Jupyter notebook
import pandas as pd
df = pd.read_csv('https://raw.githubusercontent.com/frankData612/data_612/master/State_Drug_Utilization_Data_2010/State_Drug_Utilization_Data_2010.csv', sep=',')<jupyter_output><empty_output><jupyter_text>Explore the data:<jupyter_code># Show the .head() of the dataset and specify the number of rows to print, in this case 10.
df.head(10)
# Show the .tail() of the dataset and specify the number of rows to print, in this case 10.
df.tail(10)
# Print the column names
print(df.columns)
# Print to see what is the type of your data set
print(type(df))
# Check number of rows and columns
print (df.shape)
# Use groupby() and find the mean on your selected column(s) - in this case the average of the total amount reimbursed by quarter
print (df.groupby('Quarter')['Total Amount Reimbursed'].mean())<jupyter_output>Quarter
1    18527.343723
2    24398.361005
3    21353.133388
4    22762.851187
Name: Total Amount Reimbursed, dtype: float64
{'fraction_non_alphanumeric': 0.07575757575757576, 'fraction_numerical': 0.05303030303030303, 'mean_word_length': 4.503787878787879, 'pattern_counts': {'":': 0, '<': 8, '<?xml version=': 0, '>': 8, 'https://': 1, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '2', 'dir': 'jupyter-structured-clean-dedup', 'id': '438454', 'license': 'MIT', 'n_tokens_mistral': 494, 'n_tokens_neox': 439, 'n_words': 182, 'path': 'Shenan_Smith_Assignment #1.ipynb', 'repo_name': 'shenandoah98/Data-612', 'size': '1452'}