<jupyter_start><jupyter_text>California Home Price  Clean Data<jupyter_code>import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
df = pd.read_csv('CAMedianPricesHomePrice_Clean.csv')
df.head()

df.tail()
df.info()
df.iloc[60:79]
# drop rows
df.drop(df.iloc[61:79].index, inplace=True)

# drop columns
df= df.dropna(axis='columns')
df
df.describe(include='all')
df = df.set_index('Date')
df
df.describe(include='all')  
df.info()
# remove '$'
df = df.replace({'\$':''}, regex = True)
df
df = df.replace({',':''}, regex = True)
df
df = df.astype(float)
df
df = round(df, 2)
df
df.describe()
df.to_csv('California_City_Homes_Prices_clean.csv')<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.17510853835021709, 'fraction_numerical': 0.013024602026049204, 'mean_word_length': 6.208333333333333, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, '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': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '319200', 'license': 'MIT', 'n_tokens_mistral': 292, 'n_tokens_neox': 281, 'n_words': 57, 'path': 'California_Homes/California_City_Homes_Prices_clean.ipynb', 'repo_name': 'LastAncientOne/Kaggle-Project', 'size': '691'}