<jupyter_start><jupyter_text>Look at the Data Dictionary<jupyter_code>xl = pd.ExcelFile('../input/zillow_data_dictionary.xlsx')
xl.sheet_names
dd = xl.parse('Data Dictionary')
dd.shape
dd.columns
for i in range(dd.shape[0]):
    print(dd['Feature'][i] + ' - ' + dd['Description'][i] + ' ;' )<jupyter_output>'airconditioningtypeid' -  Type of cooling system present in the home (if any) ;
'architecturalstyletypeid' -  Architectural style of the home (i.e. ranch, colonial, split-level, etc…) ;
'basementsqft' -  Finished living area below or partially below ground level ;
'bathroomcnt' -  Number of bathrooms in home including fractional bathrooms ;
'bedroomcnt' -  Number of bedrooms in home  ;
'buildingqualitytypeid' -  Overall assessment of condition of the building from best (lowest) to worst (highest) ;
'buildingclasstypeid' - The building framing type (steel frame, wood frame, concrete/brick)  ;
'calculatedbathnbr' -  Number of bathrooms in home including fractional bathroom ;
'decktypeid' - Type of deck (if any) present on parcel ;
'threequarterbathnbr' -  Number of 3/4 bathrooms in house (shower + sink + toilet) ;
'finishedfloor1squarefeet' -  Size of the finished living area on the first (entry) floor of the home ;
'calculatedfinishedsquarefeet' -  Calculated total finished living area[...]
{'fraction_non_alphanumeric': 0.10518292682926829, 'fraction_numerical': 0.003048780487804878, 'mean_word_length': 4.9411764705882355, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 4, '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': '421433', 'license': 'MIT', 'n_tokens_mistral': 422, 'n_tokens_neox': 401, 'n_words': 138, 'path': 'notebook (1).ipynb', 'repo_name': 'scollins83/kaggle_zillow_zestimate', 'size': '1312'}