Project List

01219335 Data Acquisition and Integration

First Semester, 2020. Section 450

Team 1 : JaoMhaGoldenAndTwoAngel
Jitta Koopratoomsiri
Thanida Jongarnon
Thun Thunkijjanukij
Project Name: Premier League
Description:

This project purpose is to analyze match result of the Premier League Football and its data is visualized via website by using React framework.
Data Source
- https://api-football-v1.p.rapidapi.com
- https://footystats.org/api/
- https://www.premierleague.com/

Photos:
Video Clip:
Last updated at 2020-12-21 13:34:40 by b6110545538
Team 2 : Swift
Patteera Likitamnuayporn
Siwat Ponpued
Project Name: SET Insider
Description:

Provide the price update by displaying as charts along with its related news from trustworthy sources.

Data source:
web scraping: SiamChart.com, stock.grabfocus

Status: Initialize and working on backend

Photos:
Video Clip:
Last updated at 2020-12-21 17:29:16 by b6110546640
Team 3 : 4d4442
Nutthanich Narphromar
Tetach Rattanavikran
Wijantra Cojamnong
Project Name: Restaurant API service
Description:

This Restaurant API service provides information about restaurants in Bangkok. This information includes basic information of restaurants and received ratings from Michelin Guide, Google and tripadvisor.com.

Photos:
Video Clip:
Last updated at 2020-12-21 15:15:10 by b6110545490
Team 4 : PMK
Kritpawit Soongswang
Sirawich Direkwattanachai
Chayathon Khuttiyanon
Project Name: Pokedex
Description:

Using 5 sources of data to create a Pokedex that visualize each pokemon information for Pokemon GO (which is a Pokemon game that has no Pokedex inside)

Data Source:
1. Pokemon stats
2. Pokemon GO dataset (include spawn rate, flee rate and type )
3. Pokemon type matchup
4. Pokemon egg spawn rate (Scrape from Gamepress) - (New data)
5. Pokemon image (Scrape from Gamepress) - (New data)
6. Pokemon high resolution image/video (Scrape from db.pokemongohub)

Photos:
Video Clip:
Last updated at 2020-12-21 22:57:13 by b6110546054
Team 5 : M&M
Mai Norapong
Tharathorn Bunrattanasathian
Project Name: Song Lyrics & Popularity (SLAP)
Description:

Gather song lyrics and popularity to play an instance of Game of Song Association by Elle and answer questions about the correlation between some lyrical properties like repetition or memorability of words with popularity.

Photos:
Video Clip:
Last updated at 2020-12-22 09:26:21 by b6110546011
Team 6 : อยากได้Aครับอาจารย์
Chananya Photan
Nattapol Boonyapornpong
Pawaris Wongsalung
Arisa Pangpeng
Project Name: Music Genre Reporter
Description:

Our API can be used to report various information about music. It can also be used to view the song’s popularity over the past few days or a certain amount of time, as well as check if the song is available for stream in that country or not.

Data Source:
1. Shazam API
2. Deezer API
3. Billboard API
4. Genius API

The question that our API can answer:
1. Search artist or track then it can show that track or artist information.
2. Show that particular artist’s number of fans based on the artists inside our database.
3. Show if the song is available for stream in that country or not.
4.Show artist's social media contacts.
5.Show number of artist's albums in our database.

Our GitHub repo contains the public APIs scraping part (managing_data.py) and the API sever itself on server.py which uses the data made with scraping part stored in MongoDB database and return JSON object for further implementation.

GitHub Repo Link:
https://github.com/kabilza/DAQ-Music-Data-Reporter

Photos:
Video Clip:
Last updated at 2020-12-21 20:08:04 by b6110545562
Team 7 : Cosmic Express
Thananan Eim-on
Punyawee Srithongkerd
Gunn Torcheep
Project Name: Road Data Collection
Description:

3 Datasources
Kidbright tools, find change in acceleration, that value is the roughness of the road
Node-RED mobile to find user's current location from mobile phone
Open elevation API, to find road height

Collect the data and calculate the height and the roughness of the road

Github page : https://github.com/326th/Roughness-measurement-respository

Photos:
Video Clip:
Last updated at 2020-12-20 23:58:13 by b6110545571
Team 8 : OneLoogChupAmongUs
Chananchida Fuachai
Sivanat Subpaisarn
Sirikon Songsaengthong
Phanthakan Kiatphaisansophon
Project Name: WatGunMai
Description:

Watgunmai is a project about reviewing temples around you which means anywhere in Bangkok! Our idea originates from our tourism spirit that wanted everyone to get to experience and discover great and exquisite temples.
Data sources
- Google Maps API
- MetaWeather API
- Questionnaires
- OpenUV API
- Web Scraper
- Temples list in Bangkok Wiki
Finished:
- Web Scraper
- Fetch data from Google maps API
- Integrated API
- Frontend to provide data visualisation.
- API Documentation

Photos:
Video Clip:
Last updated at 2020-12-18 22:59:23 by b6110545473
Team 9 : Tempo
Chatchapong Chumpada
Project Name: Gold-Fuel Relationship
Description:

There are many factors that affect the gold price. Fuel price is one of the factors of that will change in the same way with the gold price. This API that can get the gold price and fuel price to compare together. Also can view the specific detail of gold price or fuel price such as average price per month, highest price of gold, amount of flow of fuel price, etc.
(The data of both fuel and gold is from January to November in 2020 )

2 Data sources:
1. History of fuel price form : https://www.bangchak.co.th
2. History of gold price from : https://ทองคำราคา.com
and used Web-Scraper with Node-RED to collect the data in to MySQL database

GitHub : https://github.com/ChatchapongC/Gold-Fuel-API

Video Clip:
Last updated at 2020-12-21 21:24:39 by b6010546877
Team 10 : SpringDayBogoshipda
Vichyawat Nakarugsa
Tiranan Emson
Sukrita Kittipitayakorn
Kasidis Luangwutiwong
Project Name: Covid19AroundTheWorld
Description:

Our group will analyze the covid-19 situation around the world including the total Covid-19 cases, new cases, death cases and recovered cases and the impact of Covid-19 to the economic situation by comparing the currency rate with the new Covid-19 cases that occurred in each countries from the time Covid-19 start until now.

GitHub repository: https://github.com/EJEunjiyaz/Covid19AroundTheWorld

Photos:
Video Clip:
Last updated at 2020-12-21 15:03:46 by b6110546062
Team 11 : Survival
Kasidit Wongpaiboon
Jirawadee Sampusri
Project Name: Movie rating
Description:

Our project is used to gather information about movies in each year we have so many movies then we came up with the idea that we can find the year that has the most interesting movie from the average rating in that year and find the director that is the best one of all time or each year.

Our Movie API from
- https://rapidapi.com/
- https://data.world/

Data sharing API
Restful API development with open API

Github
https://github.com/JirawadeeSampusri/MoviesApi

Photos:
Video Clip:
Last updated at 2020-12-22 13:20:17 by b6110545457
Team 12 : PM
Sidtipat Kietchai
Natthaphon Rakprakobkij
Project Name: Weather Memo
Description:

This application is about the weather forecast and pm2.5 that can tell you about how weather today and how about today's air quality. The data source contains the weather forecast, temperature, current air quality, current weather.

Photos:
Video Clip:
Last updated at 2020-12-21 23:34:24 by b6110546402
Team 13 : SALTY
Supakorn Tangpremsri
Anant Arayanant
Wikrom Chanthakhun
Project Name: Dota 2 Statistic
Description:

This API project provides statistics of Dota2 hero including win rate and picks rate in each ranked (Guardian/Archon/Ancient/Divine) of the particular hero, the comparison of win rate and picks rate of two heroes, the stat of the hero at a particular level, and the match analysis of the particular hero.

Data source:
- Win Rate/Pick Rate: DotaBuff -- https://www.dotabuff.com/
- Image: Dota Official -- http://www.dota2.com/heroes/
- Hero Stat: docs.stratz -- https://docs.stratz.com/index.html/

Architecture:
- API Endpoint: NodeJS Strapi
- Front-End: React-JS
- Database: MongoDB

Photos:
Video Clip:
Last updated at 2020-12-20 14:58:22 by b6110545694