{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name": "waset_data_analysis.ipynb", "version": "0.3.2", "provenance": [] }, "kernelspec": { "name": "python3", "display_name": "Python 3" } }, "cells": [ { "cell_type": "code", "metadata": { "id": "mfNt1v6zr0CX", "colab_type": "code", "colab": {} }, "source": [ "import pandas as pd" ], "execution_count": 0, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "B8Km6HVJrv0Z", "colab_type": "code", "colab": {} }, "source": [ "waset_data = pd.read_csv(\"https://data.newstapa.org/datasets/%EA%B0%80%EC%A7%9C%ED%95%99%ED%9A%8C-WASET-%ED%95%9C%EA%B5%AD-%EA%B4%80%EB%A0%A8-%EB%8D%B0%EC%9D%B4%ED%84%B0/files/waset-20180727.csv\", sep=',')" ], "execution_count": 0, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "77oYp1ZFsGNp", "colab_type": "code", "outputId": "7e902809-b844-4c7c-dc11-7cac0ce523e4", "colab": { "base_uri": "https://localhost:8080/", "height": 34 } }, "source": [ "waset_data.shape" ], "execution_count": 7, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "(2441, 8)" ] }, "metadata": { "tags": [] }, "execution_count": 7 } ] }, { "cell_type": "code", "metadata": { "id": "x-taQPuxsUfu", "colab_type": "code", "outputId": "4d0d2638-0fd7-47f8-87a6-f6ec4c120e4d", "colab": { "base_uri": "https://localhost:8080/", "height": 34 } }, "source": [ "waset_data.columns" ], "execution_count": 8, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "Index(['no', '분류', '중복', 'Institution', 'Title', '저자', 'Year', 'Pdf Link'], dtype='object')" ] }, "metadata": { "tags": [] }, "execution_count": 8 } ] }, { "cell_type": "code", "metadata": { "id": "pzUbLu9wsXTm", "colab_type": "code", "outputId": "d5c05b55-0e76-4f71-efe0-beb33f28e871", "colab": { "base_uri": "https://localhost:8080/", "height": 359 } }, "source": [ "waset_data.head(10)" ], "execution_count": 9, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", " | no | \n", "분류 | \n", "중복 | \n", "Institution | \n", "Title | \n", "저자 | \n", "Year | \n", "Pdf Link | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "Periodical | \n", "0 | \n", "Seoul National University | \n", "2D and 3D Finite Element Method Packages of CE... | \n", "Choon Ki Ahn, Jung Hun Park, and Wook Hyun Kwon | \n", "2007 | \n", "https://waset.org/publications/10964/2d-and-3d... | \n", "
1 | \n", "2 | \n", "Abstract | \n", "0 | \n", "Seoul National University | \n", "A 3-Dimensional Memory-Based Model for Plannin... | \n", "Minho Lee,Donghyun Back,Jaemoon Jung,Woojin Park | \n", "2016 | \n", "https://waset.org/pdf/books/?id=52549&pageNumb... | \n", "
2 | \n", "3 | \n", "Abstract | \n", "1 | \n", "Seoul National University | \n", "A Framework for Designing Complex Product-Serv... | \n", "Yoonjung An,Yongtae Park | \n", "2015 | \n", "https://waset.org/pdf/books/?id=26766&pageNumb... | \n", "
3 | \n", "4 | \n", "Periodical | \n", "0 | \n", "Seoul National University | \n", "A Framework for Designing Complex Product-Serv... | \n", "Yoonjung An,Yongtae Park | \n", "2015 | \n", "https://waset.org/publications/10000960/a-fram... | \n", "
4 | \n", "5 | \n", "Abstract | \n", "0 | \n", "Seoul National University | \n", "A Literature Review of Ergonomics Sitting Stud... | \n", "Yoonjin Lee,Dongwook Hwang,Juhee Park,Woojin Park | \n", "2016 | \n", "https://waset.org/pdf/books/?id=52542&pageNumb... | \n", "
5 | \n", "6 | \n", "Abstract | \n", "0 | \n", "Seoul National University | \n", "A New Direction of Urban Regeneration: Form-Ba... | \n", "Hyejin Song,Jin Baek | \n", "2015 | \n", "https://waset.org/pdf/books/?id=49942&pageNumb... | \n", "
6 | \n", "7 | \n", "Abstract | \n", "0 | \n", "Seoul National University | \n", "A Review of In-Vehicle Network for Cloud Conne... | \n", "Hanbhin Ryu,Ilkwon Yun | \n", "2015 | \n", "https://waset.org/pdf/books/?id=21239&pageNumb... | \n", "
7 | \n", "8 | \n", "Periodical | \n", "0 | \n", "Seoul National University | \n", "A Review on Technology Forecasting Methods and... | \n", "Daekook Kang, Wooseok Jang, Hyeonjeong Lee, an... | \n", "2013 | \n", "https://waset.org/publications/2934/a-review-o... | \n", "
8 | \n", "9 | \n", "Abstract | \n", "0 | \n", "Seoul National University | \n", "A Strategic Approach for Promoting Renewable E... | \n", "Hanee Ryu | \n", "2015 | \n", "https://waset.org/pdf/books/?id=34233&pageNumb... | \n", "
9 | \n", "10 | \n", "Abstract | \n", "1 | \n", "Seoul National University | \n", "A Study of Mode Choice Model Improvement Consi... | \n", "Young-Hyun Seo,Hyunwoo Park,Dong-Kyu Kim,Seung... | \n", "2017 | \n", "https://waset.org/pdf/books/?id=69640&pageNumb... | \n", "
\n", " | Year | \n", "no | \n", "중복 | \n", "
---|---|---|---|
Institution | \n", "\n", " | \n", " | \n", " |
Academy of Korean Studies | \n", "2017.000000 | \n", "2274.5 | \n", "0.000000 | \n", "
Agency for Defense Development | \n", "2015.000000 | \n", "2256.0 | \n", "0.333333 | \n", "
Ajou University | \n", "2015.212121 | \n", "1100.0 | \n", "0.121212 | \n", "
Andong National University | \n", "2016.500000 | \n", "2249.5 | \n", "0.000000 | \n", "
Animal and Plant Quarantine Agency | \n", "2015.833333 | \n", "2112.5 | \n", "0.166667 | \n", "
Anyang University | \n", "2017.000000 | \n", "2335.5 | \n", "0.500000 | \n", "
Asan Medical Center | \n", "2015.000000 | \n", "2054.5 | \n", "0.000000 | \n", "
Bison Medical | \n", "2016.000000 | \n", "2259.5 | \n", "0.500000 | \n", "
Buan Water Quality | \n", "2016.000000 | \n", "2391.0 | \n", "0.000000 | \n", "
Busan National University | \n", "2007.000000 | \n", "2356.0 | \n", "0.000000 | \n", "
Busan University of Foreign Studies | \n", "2017.000000 | \n", "2367.0 | \n", "0.000000 | \n", "
Busan Water Authority | \n", "2016.000000 | \n", "2417.0 | \n", "0.000000 | \n", "
CAD/CAM Research Center | \n", "2008.000000 | \n", "2389.0 | \n", "0.000000 | \n", "
CHA university | \n", "2017.000000 | \n", "2326.5 | \n", "0.000000 | \n", "
Catholic Kwandong University | \n", "2017.000000 | \n", "2434.0 | \n", "0.000000 | \n", "
Catholic Medical Center | \n", "2017.000000 | \n", "2355.0 | \n", "0.000000 | \n", "
Catholic University of Daegu | \n", "2014.666667 | \n", "2179.0 | \n", "0.000000 | \n", "
Chang Minwoo Structural Consultants | \n", "2016.000000 | \n", "2247.5 | \n", "0.000000 | \n", "
Changwon National University | \n", "2018.000000 | \n", "2428.0 | \n", "0.000000 | \n", "
Cheongju University | \n", "2012.000000 | \n", "2218.0 | \n", "0.000000 | \n", "
Chodang University | \n", "2017.500000 | \n", "2344.5 | \n", "0.000000 | \n", "
Chonbuk National University | \n", "2015.075949 | \n", "586.0 | \n", "0.240506 | \n", "
Chonnam National University | \n", "2014.720000 | \n", "1512.0 | \n", "0.120000 | \n", "
Chosun University | \n", "2014.885714 | \n", "1309.0 | \n", "0.228571 | \n", "
Chung-Ang University | \n", "2015.111111 | \n", "1569.0 | \n", "0.222222 | \n", "
Chungbuk National University | \n", "2014.652174 | \n", "1620.0 | \n", "0.130435 | \n", "
Chungju University | \n", "2011.000000 | \n", "2406.0 | \n", "0.000000 | \n", "
Chungnam National University | \n", "2015.428571 | \n", "1843.5 | \n", "0.142857 | \n", "
DAUM Engineering Co., Ltd. | \n", "2017.200000 | \n", "2189.0 | \n", "0.400000 | \n", "
DGMIF | \n", "2017.000000 | \n", "2276.5 | \n", "0.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
Seoul National University | \n", "2015.544643 | \n", "56.5 | \n", "0.107143 | \n", "
Seoul National University of Science and Technology | \n", "2015.105263 | \n", "1815.0 | \n", "0.315789 | \n", "
Seoul Theological University | \n", "2008.000000 | \n", "2350.0 | \n", "0.000000 | \n", "
Seoul Women's University | \n", "2016.000000 | \n", "2234.0 | \n", "0.000000 | \n", "
Silla University | \n", "2014.500000 | \n", "2322.5 | \n", "0.000000 | \n", "
Sinjang Elementary School | \n", "2016.000000 | \n", "2411.0 | \n", "0.000000 | \n", "
Sogang University | \n", "2015.285714 | \n", "1990.0 | \n", "0.000000 | \n", "
Soonchunhyang Univeristy | \n", "2014.333333 | \n", "1856.5 | \n", "0.000000 | \n", "
Soongsil University | \n", "2012.457143 | \n", "1066.0 | \n", "0.114286 | \n", "
Sun Moon University | \n", "2017.000000 | \n", "2416.0 | \n", "0.000000 | \n", "
Sunchon National University | \n", "2016.000000 | \n", "2144.5 | \n", "0.000000 | \n", "
Sungkyunkwan University | \n", "2014.650000 | \n", "172.5 | \n", "0.191667 | \n", "
Sungshin Women's University | \n", "2016.000000 | \n", "2381.0 | \n", "0.000000 | \n", "
The Catholic Univeristy of Korea | \n", "2015.333333 | \n", "2048.5 | \n", "0.000000 | \n", "
Tongmyong University | \n", "2014.000000 | \n", "2362.5 | \n", "0.500000 | \n", "
U2 System Inc. | \n", "2017.000000 | \n", "2423.0 | \n", "0.000000 | \n", "
UNIENS Co. Ltd. | \n", "2015.500000 | \n", "2352.5 | \n", "0.500000 | \n", "
Ulsan College | \n", "2016.000000 | \n", "2383.5 | \n", "0.500000 | \n", "
Ulsan National Institute of Science and Technology | \n", "2014.500000 | \n", "2284.5 | \n", "0.000000 | \n", "
University of Seoul | \n", "2015.689655 | \n", "1461.0 | \n", "0.241379 | \n", "
University of Suwon | \n", "2014.000000 | \n", "2386.5 | \n", "0.500000 | \n", "
University of Ulsan | \n", "2015.120000 | \n", "1434.0 | \n", "0.120000 | \n", "
Water Quality Institute, Busan Water Authority | \n", "2016.000000 | \n", "2366.0 | \n", "0.000000 | \n", "
Wonkwang University | \n", "2015.000000 | \n", "2196.0 | \n", "0.000000 | \n", "
Woongjin Energy Co.,Ltd. | \n", "2013.000000 | \n", "2262.5 | \n", "0.000000 | \n", "
Woosong University | \n", "2015.000000 | \n", "2435.0 | \n", "0.000000 | \n", "
Yeungnam University | \n", "2014.829268 | \n", "988.0 | \n", "0.170732 | \n", "
Yongin Mental Hospital | \n", "2015.000000 | \n", "2388.0 | \n", "0.000000 | \n", "
Yonsei University | \n", "2014.923077 | \n", "284.5 | \n", "0.163462 | \n", "
You & Green Korean Medical Clinic | \n", "2016.000000 | \n", "2390.0 | \n", "0.000000 | \n", "
235 rows × 3 columns
\n", "