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.
File Explorer
- 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
# Use via CDN
jsDelivrjsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.
Command Glossary
Commands referenced in this DOCs, explained below.
git clone
View Details ▼
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
View Details ▼
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
View Details ▼
python
Python language interpreter.
python
Start a REPL (interactive shell):
python {{path/to/file.py}}
Execute a specific Python file:
python -i {{path/to/file.py}}
Execute a specific Python file and start a REPL:
