Difference between revisions of "ISSS608 2017-18 T3 Assign Anthony Theodore Method"
(added methodology) |
(added design) |
||
Line 89: | Line 89: | ||
|| | || | ||
#Create 3 new sheet. This 3 sheets will be used for mapping individual year. | #Create 3 new sheet. This 3 sheets will be used for mapping individual year. | ||
− | #*Put <i>Date</i> into the Column along with <i>X</i> and <i>Y</i> into the Rows. | + | #*Put <i>Date</i> into the Column along with <i>X</i> and <i>Y</i> into the Rows for all sheets. |
− | #* | + | #*Because we only use year 2006 - 2017, divide those year with all 3 sheets by using filter |
+ | #**In this case, sheet 1 use year 2006-2009. Sheet 2 use year 2010-2013 and sheet 3 use year 2014-2017. | ||
#Using another new sheet, add the line graph for <i>Vocalization Type</i> into Rows and year into column. | #Using another new sheet, add the line graph for <i>Vocalization Type</i> into Rows and year into column. | ||
#*Filter other visualization type and use only Call and Song. This is to give user better depth for comparison between sound and call. | #*Filter other visualization type and use only Call and Song. This is to give user better depth for comparison between sound and call. | ||
#Create another sheet to add the line graph for total of sound detected by year. | #Create another sheet to add the line graph for total of sound detected by year. | ||
+ | #Put all the sheet into a dashboard. The finalize design will be shown in next section. | ||
|- | |- | ||
| | | | ||
Line 103: | Line 105: | ||
#*We use Python to do this task. Library used is both pydub and ffmpeg. Pydub is a package that allow audio manipulation. Detail about pydub: https://github.com/jiaaro/pydub | #*We use Python to do this task. Library used is both pydub and ffmpeg. Pydub is a package that allow audio manipulation. Detail about pydub: https://github.com/jiaaro/pydub | ||
#**Note that ffmpeg need to be installed first before pydub can be used. | #**Note that ffmpeg need to be installed first before pydub can be used. | ||
− | # | + | #Using library ''librosa'', we can process all the audio file inside the .wav folder. |
|- | |- | ||
| | | | ||
Line 110: | Line 112: | ||
Audio Visualization | Audio Visualization | ||
|| | || | ||
− | + | #Using library matplotlib.pyplot in Python, we can visualize the sound wave with oscillogram and spectogram. | |
+ | #*Note that the time for all the audio will be different. | ||
|- | |- | ||
| | | | ||
Line 124: | Line 127: | ||
<font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Dashboard Design</span></font> | <font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Dashboard Design</span></font> | ||
</div> | </div> | ||
− | The | + | The following image is the finalized dashboard that will be uploaded into tableau public: |
− | + | [[Image:Tableaudash atheodore.png|1200px]] | |
− | Link for dashboard | + | <br> |
+ | The dashboard has 2 feature. It will enable user to see the distribution of each bird per year by 3 map panel on the left, and will enable user to know the total number of sound detected for all bird or for a particular bird. It can also allow user to check the comparison between song and call. On the right, user can click on the bullet point to select which bird they want to see. | ||
+ | <br> | ||
+ | Link for the dashboard: |
Revision as of 16:15, 6 July 2018
|
|
|
|
Tools and Approach
This assignment mainly use tableau for the dashboard creation and exploration analysis. SAS JMP Pro is also used for the initial data understanding part.
Python is used only for the audio visualization. The following list is the Python library used:
|
The approach taken for this assignment consists of:
- Data understanding
- Geospatial visualization
- Creating Dashboard
- Audio processing
- Audio visualization
- Audio comparison
No. |
Approach |
Description |
1. |
Data Understanding |
|
2. |
Geospatial Visualization |
|
3. |
Dashboard Creation |
|
4 |
Audio Processing |
|
5 |
Audio Visualization |
|
6 |
Audio Comparison |
Dashboard Design
The following image is the finalized dashboard that will be uploaded into tableau public:
The dashboard has 2 feature. It will enable user to see the distribution of each bird per year by 3 map panel on the left, and will enable user to know the total number of sound detected for all bird or for a particular bird. It can also allow user to check the comparison between song and call. On the right, user can click on the bullet point to select which bird they want to see.
Link for the dashboard: