FINAL PROJECT – INTERACTIVE DATA-EXPLORER

In this last project you will develop an interactive data-driven web-based Python application   that tells a story with real-world data. You will show your mastery of many coding concepts as you interact with data real-world data. You will use Pandas and Numpy modules for managing and interacting with data, Matplotlib, or Pandas charts for plotting, pydeck (or other mapping packages) for maps, and the Streamlit package for creating interactive web applications using Python.

TELL A STORY WITH REAL - WORLD  DATA

Choose one of these data sets. (All sampled to several thousand rows.)

To ensure students create a variety of projects, you will sign up for and select a data set during class. If you miss class, or if the signups are not approximately equally distributed, I will assign a data set for you to use.

PART 1.   DESIGN – WHAT DO YOU WANT TO SHOW AND TELL WITH YOUR DATA?

The purpose of this part is to get you thinking about what you might do before you start coding. Identify at least three different queries or questions you can ask about your data set and ways   to interact with and present the data based on your understanding of Pandas DataFrames,          Matplotlib, maps, and the Streamlit.io packages.

Describe how your queries will be interactive by incorporating Streamlit's user interface             elements to obtain user input. Describe how you will visually present this data using charts,       graphs, Streamlit tables or maps. For example, if analyzing housing data, you might use a           dropdown list to specify a list of neighborhoods and a slider to specify a price range. You then   might display all rooms for rent in that neighborhood within that price range using a table,        chart, or map. (That's an easy one. At least one of your queries needs to be more complex than this!)

Be sure your page is "user friendly" and as "polished" as possible. Be sure to label controls requiring user interaction, make sure your charts have titles, legends or explanations that would be helpful to the user.

You may change your queries or visualizations after you start coding if you need to change your plans. If you do this, please notify me during the development period.

Feel free to add to your project as you explore Pandas and Streamlit capabilities and find cool ways to implement new or additional features. Part of your grade will be a

"complexity/originality" score. If you use a module or do something cool that we may not have discussed in class or implement more than the minimum requirements, you will receive a            higher score.

A complexity score of 2 means you implemented the minimum requirements for this project. A complexity score of zero means you didn’t meet the requirements.

As you write your program, be sure to include code that demonstrates each of these items. Each contributes to your project grade (see the rubric below).

Python Coding

At least any four of these:

1.   Functions:

a.   At least one function that has two parameters that returns a value

b.   At least one function with a default parameter that returns a value

c.   At least one function that does not return a value

2.   Lists and Loops:

a.   A list comprehension

b.   A loop that iterates through items in a list, dictionary, or tuple

3.   Data Structures:

a.   Code that uses at least two different methods of lists, dictionaries, or tuples. (Also see a separate Pandas requirement below.)

Charts and Maps

At least three (3) different charts

1.   Well labeled and Titled

2.   Use legends, colors, labels, titles, as appropriate

3.   At least one map (st.map is only partial credit) – for full credit, include dots, icons, or other map features

Pandas

At least four (4) of these

1.   Sorting data in ascending or descending order, by one or more columns

2.   Filtering data by one condition

3.   Filtering data by two or more conditions with AND or OR

4.   Analyzing data with pivot tables

5.   Add/drop/select/create new/group columns, frequency count, other features as you wish

6.   Try doing text analysis – find common words in titles, etc., or searching for locations with a particular name.

Streamlit

At least three (3) different UI Controls

1.   Sliders, drop downs, multi-selects, text box, etc.

2.   Page design features (sidebar, fonts, colors, images, navigation)

3.   Well-designed, professional-appearing, interactive website

The usual rules about writing "good" code apply.

•   Be Pythonic! Make your code as modular and easy to follow as possible

•   Include a docstring, comments, and meaningful variable names.

•   If you did something "cool" in your code that you are incredibly proud of, please write a comment call attention to what you did.

•   If you referred to any online articles or other information beyond class examples, please be sure to list them as references / comments in your code.

•   Make sure the program runs and the output is correct.

Python has several modules developed by other Python programmers that we have not               covered during this semester. You are welcome to explore other package or modules (especially those available for visualizing data) which are available in Python's Package Index. Use one in a

meaningful way in your project for extra credit. Examples include Seaborn charts, Folium maps,

WordCloud, etc. Seehttps://pypi.org/for the complete list.

Post your application to the web. Sign up for a free Streamlit Cloud community account at

https://streamlit.io/cloudand follow the instructions to publish your app.