PandasError: DataFrame constructor not properly called

[akelai]

In the "Ingest_Data_Into_PostgreSQL.ipynb" jupyter notebook, the last command (26) does not work and gives a python error.

Command:

Finally, we want to label the 5 types of weather data noted above with human-readable names. We create a dictionary mapping each label to its description, create a Data Frame from that, and write it to the database

weather_type_dict = {'PRCP': 'Precipitation', 'SNOW': 'Snowfall', 'SNWD': 'Snow Depth', 
                     'TMAX': 'Maximum temperature', 'TMIN': 'Minimum temperature'}
weather_type_df = DataFrame(weather_type_dict.items(), columns=['weather_type', 'weather_description'])
description_table_name = 'weather_types'
weather_type_df.to_sql(description_table_name, conn, index_label='id')

Error when executed:

...
----> 3 weather_type_df = DataFrame(weather_type_dict.items(), columns=['weather_type', 'weather_description'])
...
PandasError: DataFrame constructor not properly called!

[akelai]

Fixed: it's because for Python3, the 3rd line has to be

weather_type_df = pd.DataFrame(list(weather_type_dict.items()), columns=['weather_type', 'weather_description'])