(All the code only needs to be written in general, no need to complete the code, only need to complie. Please make sure that the logic is correct.)
1.Write a Temperature class to hold the data, partially listed below. in a named tuple. The class should contain a constructor, a string conversion function.
2.Using your SQLite class write a member function __getitem__which returns the median data for a given year.
3.Write a Database class that has a SQLite data base member to hold the Temperature class data. The class should contain a constructor, which makes a connection and initializes the table.
4.Write a function to convert a defaultdict, like the following:
{'Cat':2,'Dog':3,'Bird':4,'Fish':6,'Elephant':5}
Into a Pandas DataFrame. The function should receeive the dictionary as a paramater.
and return the DataFrame.