Write some short code.
(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.