College_Practicals
Collection of AI, Data Structures, Data Science, DBMS, and OOP practicals implemented in Python, aligned with the SPPU 2024 curriculum. Includes clear, beginner‑friendly implementations and mini‑projects for learning and portfolio showcase.
파일 탐색기
- practical_01_advance.ipynb
- practical_01_advance.py
- practical_01_basic.py
- practical_02_advance.ipynb
- practical_02_advance.py
- practical_02_basic.py
- practical_03_advance.ipynb
- practical_03_advance.py
- practical_03_basic.py
- csp_aust_map_col.ipynb
- csp_aust_map_col.py
- practical_04_advance.ipynb
- practical_04_advance.py
- practical_04_basic.py
- practical_05_advance.ipynb
- practical_05_advance.py
- practical_05_basic.py
- practical_06_advance.ipynb
- practical_06_advance.py
- practical_06_basic.py
- README_AI.md
- requirements.txt
- LA_PCA_results.png
- practical_01_advance.ipynb
- practical_01_basic.ipynb
- practical_02_advance.ipynb
- stats_ci_ttest.png
- stats_viz.png
- practical_02_basic.ipynb
- corr_heatmap.png
- eda_group.png
- feat_eng.png
- missing.png
- outliers.png
- practical_03_advance.ipynb
- Iris.csv
- practical_03_basic.ipynb
- eval.png
- feat_imp.png
- practical_04_advance.ipynb
- Titanic-Dataset.csv
- practical_04_basic.ipynb
- Titanic-Dataset.csv
- HousingData.csv
- model_compare.png
- practical_05_advance.ipynb
- residuals.png
- HousingData.csv
- practical_05_basic.ipynb
- cm_pr.png
- practical_06_advance.ipynb
- roc.png
- spambase.csv
- threshold.png
- tifidf_imp.png
- practical_06_basic.ipynb
- spambase.csv
- Practical_07.pbix
- retail_sales_dataset.csv
- Dashboard_Preview.png
- Dashboard_Preview_02.png
- readme_07.md
- Practical_08.pbix
- WA_Fn-UseC_-HR-Employee-Attrition.csv
- Dashboard_Preview.png
- Dashboard_Preview_02.png
- readme_08.md
- README_DS.md
- requirements.txt
- DS_unit03.ipynb
- DS_unit03.py
- DS_unit04.ipynb
- DS_unit04.py
- Practical_01.c
- Practical_02A.c
- Practical_02B.c
- Practical_03.c
- Practical_04.c
- Practical_05.c
- Practical_06.c
- Practical_07.c
- Practical_08.c
- Practical_09A.c
- Practical_09B.c
- Practical_10.c
- Mini_Project.py
- Practical_01A.py
- Practical_01B.py
- Practical_02.py
- Practical_03.py
- Practical_04.py
- Practical_05.py
- Practical_06.py
- Practical_07.py
- Practical_08.py
- Practical_08_adv.py
- Practical_09.py
- README_DS.md
- requirements.txt
- extra01.sql
- Screenshot 2026-05-04 004446.png
- Screenshot 2026-05-04 004459.png
- Screenshot 2026-05-04 004512.png
- extra02.sql
- Screenshot 2026-05-04 005010.png
- Screenshot 2026-05-04 005021.png
- Screenshot 2026-05-04 005032.png
- Screenshot 2026-05-04 005044.png
- Screenshot 2026-05-04 005054.png
- Screenshot 2026-05-04 005131.png
- extra03.sql
- Screenshot 2026-05-04 005338.png
- Screenshot 2026-05-04 005347.png
- Screenshot 2026-05-04 005403.png
- Screenshot 2026-05-04 005411.png
- extra04.sql
- Screenshot 2026-05-04 010306.png
- Screenshot 2026-05-04 010316.png
- Screenshot 2026-05-04 010326.png
- Screenshot 2026-05-04 010341.png
- Screenshot 2026-05-04 010357.png
- extra05.sql
- Screenshot 2026-05-04 010920.png
- Screenshot 2026-05-04 010930.png
- Screenshot 2026-05-04 010941.png
- Screenshot 2026-05-04 010951.png
- Screenshot 2026-05-04 011001.png
- Screenshot 2026-05-04 011011.png
- Screenshot 2026-05-04 011021.png
- extra06.sql
- Screenshot 2026-05-04 011528.png
- Screenshot 2026-05-04 011537.png
- Screenshot 2026-05-04 011545.png
- Screenshot 2026-05-04 011558.png
- Screenshot 2026-05-04 011610.png
- extra07.sql
- Screenshot 2026-05-04 011735.png
- Screenshot 2026-05-04 011743.png
- extra08.json
- Screenshot 2026-05-04 011052.png
- Screenshot 2026-05-04 011058.png
- Screenshot 2026-05-04 011108.png
- Screenshot 2026-05-04 011115.png
- Screenshot 2026-05-04 011122.png
- Screenshot 2026-05-04 011130.png
- Screenshot 2026-05-04 011136.png
- extra09.json
- Screenshot 2026-05-04 010450.png
- Screenshot 2026-05-04 010508.png
- Screenshot 2026-05-04 010517.png
- Screenshot 2026-05-04 010526.png
- Screenshot 2026-05-04 010544.png
- Screenshot 2026-05-04 010554.png
- ER-Diagram.png
- README.md
- preview-01.png
- preview-02.png
- preview-03.png
- preview-04.png
- preview-05.png
- preview-06.png
- preview-07.png
- preview-08.png
- preview-09.png
- preview-10.png
- preview-11.png
- preview-12.png
- preview-01.png
- preview-02.png
- preview--01.png
- preview-02.png
- analysis.sql
- rollback.sql
- schema.sql
- seed.sql
- transaction.sql
- Lab Manual DBMS v2.pdf
- practical_01.sql
- practical_02.sql
- practical_03.sql
- practical_04.sql
- practical_05.sql
- practical_06.sql
- practical_07.json
- practical_08.json
- practical_09.sql
- er-diagram.png
- README.md
- preview-01.png
- preview-02.png
- analysis.sql
- schema.sql
- seed.sql
- er_diagram.png
- README.md
- courses_table.png
- enrollment_table.png
- student_courses_view.png
- student_table.png
- analysis.sql
- schema.sql
- seed.sql
- er-diagram.png
- README.md
- preview_01.png
- preview_02.png
- preview_03.png
- preview_04.png
- preview_05.png
- preview_06.png
- analysis.sql
- schema.sql
- seed.sql
- er-diagram.png
- README.md
- preview-01.png
- preview-02.png
- preview-03.png
- preview-04.png
- preview-05.png
- preview-06.png
- analysis.sql
- schema.sql
- seed.sql
- er-diagram.png
- README.md
- preview-01.png
- preview-02.png
- preview-03.png
- preview-04.png
- analysis.sql
- schema.sql
- seed.sql
- er-diagram.png
- README.md
- preview-01.png
- preview-02.png
- preview-03.png
- preview-04.png
- preview-05.png
- preview-06.png
- analysis.sql
- schema.sql
- seed.sql
- practical07_playground.mongodb.js
- README.md
- aggregate_average.png
- aggregate_filter.png
- aggregate_groupby.png
- aggregate_total.png
- DB_Creation.png
- deletion.png
- index_create_on_email.png
- index_creation.png
- index_show.png
- Insertion.png
- Visualization.png
- practical08_playgroundmongodb.js
- README.md
- Aggregate_Function.png
- Creating_post_collection.png
- DB_creation.png
- Delete.png
- Indexing.png
- Insert_view.png
- Insertion.png
- Update.png
- er-diagram.png
- Backup_and_Recovery.md
- README.md
- preview-01.png
- preview-02.png
- preview-03.png
- preview-04.png
- preview-05.png
- preview-06.png
- preview-07.png
- analysis.sql
- analysis_backup.sql
- schema.sql
- schema_backup.sql
- seed.sql
- seed_backup.sql
- trial_er_diagram.png
- README.md
- schema.sql
- .gitignore
- README_DBMS.md
- README.md
- Practical_01_Advance.ipynb
- Practical_01.ipynb
- Practical_02.ipynb
- Practical_02.ipynb
- Practical_03_Advance.ipynb
- Practical_03.ipynb
- Practical_04.ipynb
- Practical_04.ipynb
- Practical_05_Advance.ipynb
- Practical_05.ipynb
- Practical_06_Advance.ipynb
- Practical_06.ipynb
- Practial_07_Advance.ipynb
- Practical_07.ipynb
- Practical_08_Advance.ipynb
- Practical_08_Advance_Extra.ipynb
- Practical_08.ipynb
- Practical_08_extra.ipynb
- README.md
- requirements.txt
- Practical_01_advance.ipynb
- Practical_01.ipynb
- Practical_02_Advance.ipynb
- Practical_02.ipynb
- Practical_03.ipynb
- README.md
- requirements.txt
- Inventory.java
- Main.java
- Product.java
- explainer_prompt.txt
- Java_OOP_Concise_Manual_HJ.pdf
- Abstract.java
- ArrayOperations.java
- ATMSimulation.java
- Calculator.java
- Ecommerce.java
- Inheritance.java
- Interface.java
- Overloading.java
- Calculator.java
- MathOverloadingDemo.java
- EcommerceOrder.java
- ArrayOperation.java
- SingleInheritance.java
- Main.java
- Main.java
- ATM_Machine.java
- database.sql
- Main.java
- database.sql
- Main.java
- README_OOP.md
- distribution_plot.png
- traffic_analysis_case_study.ipynb
- traffic_plot.png
- salary_experience.png
- salary_experience_correlation.ipynb
- README_PS.md
- .gitignore
- banner.png
- README.md
- requirements.txt
# CDN으로 사용하기
jsDelivrjsDelivr는 공개 GitHub 리포지토리를 별도 설정 없이 CDN으로 즉시 서빙합니다. 버전과 파일을 고르면 웹페이지에 바로 붙일 수 있는 링크와 예시 코드가 만들어집니다.
명령어 용어집
이 문서에서 사용된 명령어를 모아봤습니다. 낯선 명령어가 있다면 펼쳐서 확인해보세요.
git clone
설명 보기 ▼
git clone
Clone an existing repository.
git clone {{remote_repository_location}} {{path/to/directory}}
Clone an existing repository into a new directory (the default directory is the repository name):
git clone --recursive {{remote_repository_location}}
Clone an existing repository and its submodules:
git clone {{[-n|--no-checkout]}} {{remote_repository_location}}
Clone only the `.git` directory of an existing repository:
pip install
설명 보기 ▼
pip install
Install Python packages.
pip install {{package1 package2 ...}}
Install one or more packages:
pip install {{package1 package2 ...}} {{[-U|--upgrade]}}
Upgrade all specified packages to the latest version, installing any that are not already present:
pip install {{package}}=={{version}}
Install a specific version of a package:
python
설명 보기 ▼
python
Python 언어 인터프리터.
더 많은 정보: <https://docs.python.org/using/cmdline.html>.
python
REPL(대화형 셸) 시작:
python {{path/to/file.py}}
특정 Python 파일 실행:
python -i {{path/to/file.py}}
특정 Python 파일 실행 후 REPL 시작:
