공공데이터(오픈데이터) API 사용법
Learn to access and use open public data with various programming languages. Data analysis, data science, and programming skills.
Course Content
공공데이터(오픈데이터) API 사용법 is an intermediate-level Udemy course taught by ITGO 아이티고. It runs 19h 14m, is taught in Korean, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 41 reviews, with 380 students enrolled. It is a paid course, last updated April 2024.
Learn to Access and Utilize Open Public Data with Various Programming Languages
This comprehensive course teaches you how to retrieve and leverage diverse open datasets from the Open Public Data Portal using multiple programming languages. You'll master how to handle JSON data received from these APIs and apply it to practical projects. The curriculum is structured into four parts, covering essential concepts and hands-on application.
Part 1: Mastering JSON Data Handling with JavaScript
- Understanding Public Data (Open Data) APIs: Get a foundational understanding of how public data APIs work and how to interact with them.
- JSON Fundamentals: Learn the core concepts of JSON (JavaScript Object Notation), including JSON objects vs. JSON arrays.
- JavaScript Basics for JSON: Develop essential JavaScript skills for effectively parsing and manipulating JSON data.
- Handling Nested JSON: Extract and utilize data from complex, nested JSON structures using loops.
- Converting JSON to Data Structures: Transform JSON data into usable JavaScript objects and strings.
- Displaying JSON on Web Pages: Implement various techniques to present JSON data on web pages, including multiple methods for effective visualization.
Part 2: Public Data APIs with Java & JSP
- Navigating the Public Data Portal: Learn to effectively use the Public Data Portal website to find and access datasets.
- Java (Eclipse) API Requests: Make API requests and output JSON data using Java and the Eclipse IDE.
- JSON to HTML Tables: Convert JSON data into formatted HTML tables using
getJSON()and other techniques. - Servlet & JSP Integration: Explore integrating JSON data with Servlets and JSP for dynamic web applications.
- Practical JSP & JSON Examples: Hands-on exercises demonstrating the integration of JSP and JSON data.
- Bootstrap Responsive Tables: Learn to display JSON data in responsive tables using Bootstrap.
Part 3: Python for Data Extraction and Processing
- JSON Data Handling in Python: Learn Python's built-in JSON module for parsing and manipulating JSON data.
- Python Data Structures & Loops: Master dictionary data structures and loops for efficient data processing.
- Python Libraries for Public Data APIs: Utilize Python libraries to simplify API interactions.
- URL Encoding & Decoding: Learn to handle URL encoding and decoding, including using
urllib.parsefor password changes and query string manipulation. - Korean Character Encoding: Understand and manage Korean character encoding (e.g.,
quote,unquote). - CSV to JSON Conversion: Convert data from CSV files to JSON format using the Public Data API.
Part 4: APIs and Database Integration
- SQLite3 Database Basics: Learn the fundamentals of using SQLite3 databases.
- Storing CSV Data in SQLite: Import data from CSV files into SQLite databases.
- Data Manipulation in SQLite: Learn to delete data from SQLite databases.
Want AI in your product? Hire the team behind TutorialSearch.io
LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.