Linux & DASH 

You can set DASH from the customizer.

About DASH and how Experience matters.

The Dash framework is utilized by many researchers for public data utilization and visualization due to its support for various programming languages, the ability to update interactive graphs in real-time, the capacity to create and customize a wide range of charts, and the integrated management from data collection to visualization.

LEARN MORE

About Bootstrap

Bootstrap is a free, open-source front-end framework for developing responsive, mobile-first websites. It offers ready-made design templates and components, making web development quicker and easier.

Snippets

Components

Framework

Dashboard


Basic admin dashboard shell with fixed sidebar and navbar.

View DEMO
Cover


A one-page template for building simple and beautiful home pages.

View DEMO
Album


Simple one-page template for photo galleries, portfolios, and more.

View DEMO

Examples – Bootstrap v5.3

Quickly get a project started with any of our examples ranging from using parts of the framework to custom components and layouts.

Headers

Display your branding, navigation, search, and more with these header components

View DEMO

Heroes

Set the stage on your homepage with heroes that feature clear calls to action.

View DEMO

Features

Explain the features, benefits, or other details in your marketing content.

View DEMO

Sidebars

Common navigation patterns ideal for offcanvas or multi-column layouts.

View DEMO

Footers

Finish every page strong with an awesome footer, big or small.

View DEMO

Dropdowns

Enhance your dropdowns with filters, icons, custom styles, and more.

View DEMO

List groups

Extend list groups with utilities and custom styles for any content.

View DEMO

Modals

Transform modals to serve any purpose, from feature tours to dialogs.

View DEMO
CASE STUDY

MySQl(DB CREATE)

{user@loaclhost]# mysql -u root -p
Root password: ******
#DB name:weather
CREATE DATABASE IF NOT EXISTS weather;
USE weather;
#TABLE Name:weather_data
CREATE TABLE IF NOT EXISTS weather_data
(sdate VARCHAR(255), #ex)field1
stationcode VARCHAR(255), #ex)field2
itemcode VARCHAR(255), ex)field3
timecode VARCHAR(255), ex)field4
value FLOAT
);

CASE STUDY

Methods of Utilizing Public Data

In order to collect public data and store it in MySQL, in python, we often use the requests library to collect data from API, and the pymysql library to store data in MySQL.
Below is a basic code example:

import requests
import json
import pymysql
import schedule
import time
# MySQL connection
db = pymysql.connect(host=’localhost’, user=’your_username’, password=’your_password’, db=’mydata’, charset=’utf8′)
def job():
# API request
response = requests.get(“your_open_api_url”)
data = response.json() # data conversion to JSON format
# Create MySQL cursor
cursor = db.cursor()
# Save data to DB
for item in data:
sql = “INSERT INTO your_table_name (column1, column2, …) VALUES (%s, %s, …)”
cursor.execute(sql, (item[‘key1’], item[‘key2’], …))
db.commit() # Reflect to DB
# Schedule setting
schedule.every().day.at(“00:00”).do(job) # Perform work at 00:00 every day
schedule.every().day.at(“12:00”).do(job) # Perform work at 12:00 every day
while True:
schedule.run_pending()
time.sleep(1)

Python (공공데이터 수집)

import xml.etree.ElementTree as ET
import requests
import mysql.connector
# API 요청
url = ‘url=’서비스주소’
params ={‘serviceKey’ : ‘발급받은 엔코딩키’,
‘pageNo’ : ‘1’, ‘numOfRows’ : ’10’, ‘resultType’ : ‘XML’, ‘date’ : ‘20171208’, ‘stationcode’ : ‘1’, ‘itemcode’ : ‘90303’, ‘timecode’ : ‘RH02’}
response = requests.get(url, params=params)
content = response.content
# XML 파싱
root = ET.fromstring(content)
# MySQL 연결
cnx = mysql.connector.connect(user=’your_username’, password=’your_password’, host=’localhost’, database=’weather’)
cursor = cnx.cursor()
# XML 데이터를 MySQL에 입력
for item in root.findall(‘.//item’):
sdate = item.find(‘sdate’).text
stationcode = item.find(‘stationcode’).text
itemcode = item.find(‘itemcode’).text
timecode = item.find(‘timecode’).text
value = item.find(‘value’).text
add_data = (“INSERT INTO weather “
“(sdate, stationcode, itemcode, timecode, value) “
“VALUES (%s, %s, %s, %s, %s)”)
data = (sdate, stationcode, itemcode, timecode, value)
cursor.execute(add_data, data)
# MySQL 커밋
cnx.commit()
cursor.close()
cnx.close()