POLYTECHNIC

CENTER OF ACADEMIC EXCELLENCE

Approved by AICTE New Delhi.
Recognized by the Govornmont of
hlaharashtra and Affiliated to MSBTE
Mun›bal Kennedy Road. Near RTO, Pune
411001
Institute Code. 0141

Academic Year: 2023-2024

IN-PLANT TRAINING REPORT ON

“Analysis of Data Science
using Python”

Course: DIPLOMA
Branch: COMPUTER ENGINEERING

SUBMITTED TO THE ALL INDIA SHRI SHIVAJI MEMORIAL SOCIETY'S,

POLYTECHNIC, PUNE

BY

Name: Sonali Amit Patki

Roll No.: 1661
UNDER THE GUIDANCE
OF
Mrs. Shirode
 VISION AND MISSION OF THE COMPUTER DEPARTMENT

VISION:

“Enhance skills by providing value based technical education for fulfilling global needs in
ihc field of computer engineering.*

MISSION:

To provide quality education in computer engineering by improving

Psychomotor skills.

To develop positive attitude, communication skills,

team spirit and ent reneurshi .

To develop awareness aboui societal and ethical responsibility for

Professionalism.
 INDEX

Sr. No. Content Page No.

1 Index / Content Page 3

2 Certificate by Institute 4

3 Acknowledgement 5

4 Abstract 6

5 Chapter 01 7

6 Chapter 02 8

7 Chapter 03 10

8 Chapter 04 11

9 Chapter 05 13

10 Chapter 06 16

11 Chapter 07 17

12 Chapter 08 19

13 Chapter 09 20

14 Chapter 10 24

15 References / Bibliography 2d

16 Weekly Diary 27

17 Attendance 28

18 Certificate Given by Industry 29

 Maharashtra State Board of Technical
Education

Certificate of Completion
Of Industrial Training
(By respective Head of Institute & Head of Department)

This is to certify that Mr./Ms. Sonali Amit Patki

With Enrollment No. 2101410243 has successfully completed

Industrial Training (22049) in Sofcon India Pvt Ltd from 07/06/2023 to

19/07/2023 for partial

fulfilment towards completion of Diploma in Computer Engineering from AISSMS

Polytechnic, Pune Institute Code 0141.

Signature
Signature
Head of the Department
Head of the Institute
 Acknowledgement

I feel immense pleasure in thanking my mentor Prof. P.P.Bastawade for his/her support,

constant encouragement, consistent guidance and inspiration throughout this In-plant

training. His/Her willingness to motivate me contributed tremendously to my In-plant project

and its report. His/Her guidance and discussions with him/her are invaluable in realization

of this In-plant report.

I express my sincere thanks to our H.O.D, Prof. V. N. Kukre, for providing all the

facilities towards completion of this In-plant Training.

I thank Prof. V. V. Shetkar Training & Placement Officer, AISSMS Polytechnic,

Pune for his valuable suggestion regarding this In-plant training.

I would like to acknowledge Principal, Prof. S. K. Giram for providing with a good

environment and facilities to complete this In-plant Training. I am also

thankful to the staff of Computer Engineering Department.

Finally, an honorable mention goes to my family and friends for their understanding

and support shown towards me in completing this In-plant training

project.

Page 5
 Abstract
Data are those raw facts and figures with no proper information hence need to be processed to
get the desired information. While information is those results which we get after processing the
raw data in different levels or extracted conclusions from a given dataset through a process
called data analysis.

Data Analysis is simply the analysis of various data means cleaning the data, transforming it into
understandable form, and then modeling data to extract some useful information for business use
or an organizational use. It is mainly used in taking business decisions. Many libraries are
available for doing the analysis. For example, NumPy, Pandas, Seaborn, Matpotlib,etc.

Data visualization will help the data analysis to make it more understandable and interactive by
plotting or displaying the data in pictorial form. Pandas, a Python open- source package that
deals with three different data structures: series, dataframes, and panels, solves that need of
analyzing and visualization of data.

Data analysis using Python makes task easier since Python Programming language has many
advantages over any other programming language. It has prominent features like being a high-
level programming language (the codes are in human readable form) it is easy to understand and
use by any programmer or user. Many libraries and functions for statistical, numerical analysis
are available in Python

Page 6
 Chapter 1

ORGANIZATIONAL STRUCTURE OF INDUSTRY

CEO

Marketing
HR i Developent Head
Head
Admin I
Finance
Graphics Designer
Testing Team

SEO Expert Cloud

Computing Team
Sales Content
Manager Creator Technical Product
Mananger

So#waeDev
Head

Python Team
Java wordPress App & Web AI & Javascript CPI Team
Team Team Dev Team Blockchain Team
Team

Page
7
 Chapter 2
INTRODUCTION OF INDUSTRY

INTRODUCTION TO Sofcon India Pvt Ltd

India Pvt Ltd is NSDC (National Skill Development Corporation), MSDE (Ministry of
Skill Development & Entrepreneurship-Govt. of India) Affiliated & Funded Company. We
are also affiliated with ESSCI (Electronic Sector Skill Council), IASC (Instrumentation
Automation Surveillance & Communication Sector Skill Council) & HSSC (Healthcare
Sector Skill Council).

Sofcon India Pvt. Ltd. (An ISO 9001:2015 Certified) is knowledge based multi-
disciplinary training company. and professionally run by technocrats having 03 decades of
rich experience in providing turnkey solutions for applications like Power Plants ,Cement
Plants, Oil & Gas Plants, Petrochemical Plants, pharmaceutical Plants, Refineries, Food
Processing Plants, Water Treatment Plants, Process Plants, Fertilizer, DG Automation,
Energy Monitoring, Load Management, Material Handling, PLC-SCADA System,
Automobile, Ash Handling, Coal Plants......and many more.

Sofcon have a vast experience in training / process solutions / manufacturing industries.

Carrying this vast experience, we are better placed to understand the exact skill set
requirement of various Indian & overseas industries therefore our training programs focus
on practical in our labs, Simulation kits, and on-site exposure, bridging the gap between
industry and academia.

Page 8
HISTORY OF SOFTCON

Sofcon India Private Limited (SIPL) is a Private Limited Indian Non- Government
Company incorporated in India on 04 June 2002 and has a history of 21 years and
one month. Its registered office is in North West Delhi, Delhi, India.

The Corporate is engaged in providing technical training services.

VISION:-
• To be the Brand bridging gap between Industry & Academia.
• To be a workplace where everyone is inspired to be the best they can be.
• To inspire innovation, learning, creativity.
• To be a responsible, effective, dynamic and fast-moving organization.
COURSES PROVIDED BY COMPANY ARE:-

1) Full stack java

2) Data Science
3) Software Testing
4) Digital Marketing
5) Python
6) Android application Development

Page 9
 Chapter 3

TYPES OF EQUIPMENTS USED IN INDUSTRY

__________________________________________________________________________________________

SOFCON INDIA PVT.LTD is a service based Software & Hardware Related Training &
Placement Company, the major services provided are Training of Software & Hardware tools
and Maintenance related work is done by the company. Major System are there are server room
and many software/hardware and maintenance related system like Computer system and
router etc. are used.

Page 10
 Chapter 4

MANUFACTURING PROCESS, PLANING AND CONTROL

________________________________________________________________________________

DEVELOPMENT PROCESS AND PLANNING:

It is a well-established fact that Python is one of the most popular programming languages
in both the coding and Data Science communities. But have you ever wondered why
Python is so popular? What is the secret behind Python's worldwide success and fame?
Python offers many GUI toolkits and frameworks that make desktop application development a
breeze. PyQt, PyGtk, Kivy, Tkinter, WxPython, PyGUI, and PySide are some of the best
Python-based GUI frameworks that allow developers to create highly functional Graphical
User Interfaces (GUIs).
Python packages and applications aim to simplify the process of software development.
The development process of data science typically follows a structured and iterative
process
So, here are main steps of Data analysis using Python:

1) Data Requirement specification

2) Data Collection

3) Data Processing

4) Data Cleaning

5) Data analysis

6) Maintenance

Page 11
 STEPS PLANNING GUIDE FOR SOFTWARE DEVELOPMENT
PROJECTS

• Project analysis :- This is the first step of the scoping stage of a software project
requested by a customer
• Requirements Gathering
• Planning
• Design & Prototyping
• Measuring and tracking progress
• Development & coding
• Testing & coding
• Deployment to Production
• Support & Maintenance

STEPS TO CREATE AN APPLICATION

• Open Jupyter Notebook.
• Click on new.
• Click on Python3.
• After creating a new project we will see a cell block.
• And you are ready to do your further coding.

Page 12
 Chapter 5
TESTING RAW MATERIALS / COMPONENTS

_________________________________________________________________________________________

Raw material testing is essential to ensure the identity, strength, quality, and purity of the
products that you produce. Sofcon India pvt ltd is a Industrial training company, so major
products delivered by the company are the software applications and hardware components
required for various courses. So, to test those applications various software testing tools are
used (selenium) and scheduled testing of the hardware components is done. There testing tools
are then used to check the part of the code and automation testing is done on it. Not only
automated testing, the manual testing is also done by creating test-cases and implementing
them and recovering the test results.
After this, an analysis is done whether the product have passed the testing process what is it run
rate and success rate etc. After considering all these factors, it is delivered to the customer if
all developing and testing team has gain confidence on the product.
TESTING

Still, the delivery of a reliable network is not done without quality testing. You'll have to
check:
Compliance with project requirements
Meeting the budget and time estimates
Durability of components
Code quality and other relevant network metrics.
That is why this step of the planning process requires you to have these aspects set in place
before starting the actual work.
Oftentimes, development and testing are conducted simultaneously to make sure each
network feature your team is developing is bug-free and ready to go.
However, once the software solution is completely developed, it still needs a full round of
testing to make sure the final product is working as it should and it's bug- free and useful to
end-users.

Page 13
This is why we have this step separate — it's also a stage that takes more time to finish. The
testing and quality assurance phase can also be covered by an external team. If that's the case,
they can provide a separate plan for this stage

1.2)Quality Assurance & Quality Control

The quality assurance process helps a business ensure its products meet the quality
standards set by the company or its industry. Another way to understand quality
assurance (QA) is as a company's process for improving the quality of its products.
Many businesses view their QA program as a promise to internal stakeholders and
customers that the company will deliver high- quality products that provide a positive
user experience.

• What quality assurance engineers do?

QUALITY ASSURANCE VS QUALITY CONTROL

Page 15
The roles of quality assurance engineers will vary by company and industry. Using software as
an example, a QA engineer's job description might include the following responsibilities:

• Usability testing

• Feature testing

• System testing
• Integration testing
Creating test plans built on automated scripts to test the product Developing standards
to ensure quality software code

• What's an Example of Quality Assurance in Practice?

The following hypothetical story illustrates how quality assurance might work in a
business. ABC roofing company has a leak problem.

The problem:
A national roofing installer receives an increase in customer complaints about leaks.
The common thread is that customers whose roofs were installed within the last six
months are experiencing leaks during the first rain.

The source:
The QA team investigates and finds that the company's roof tile supplier changed the
composition of its tiles. After speaking with experts, the team realizes the supplier's
cheaper components make their tiles more porous.

The solution:
The QA team alerts the executives, who put pressure on the supplier to improve its
tile quality or lose the company as a customer. The QA team then writes a new
policy requiring a weather test for any new materials added to the company's roof
installation process.

Page 16
 Chapter 6

MATERIAL HANDLING PRODUCTS & PROCEDURES

________________________________________________________________________________

Sofcon is a software company so Equipment's like pulleys, cranes, etc are not used.
Whereas the company has major equipment like various operating systems, IDE's for
different languages, software testing tools, hardware like pc, CPU etc.

Page 17
 Chapter 7

SAFETY PROCEDURE AND GEAR USED

_________________________________________________________________________________________

Safety procedure Followed:-

The safety procedures are followed to maintain the software,code & data of company's
every customer.
The passwords must be provided to the devices and only the required people must know them.
The admin must assign privilege levels for each system user.

1) Database maintainence: Maintaining the current database system and providing

efficient updates for any bugs in future.

2) Database Backup: Maintaining a standard backup of Database.

3) Network performance: Analyzing top network performance concerns influencing the speed and
reliability of your devices, including bandwidth usage, traffic patterns, bottlenecks, frequently down or
crashed servers, connection lags, delays and more.

4) Regular hardware and software updates: Scheduling updates propagated across the database,
which in turn bolsters both the project's overall performance and security defenses.

5) IT infrastructure compliance: Maintaining internal compliance with company practices as

well as external government regulations and industry policies.

Page 18
 Chapter 8

PRACTICAL EXPERIENCE PARTICULARS OF INDUSTRY

As I have taken Data Analysis as my industrial training domain, the industry taught me Python
programming language . Adapting a new programming language is tricky yet an interesting
task. The basic concepts were same in Python but syntaxe was somewhat unique.
The industry trainers taught each and every concept from basics to advance and also helped
to apply them in form of programs as a practical part. My work after completing the training
was to apply these programming concepts in form of mini- projects.
At SOFCON, I worked on a Data analysis using Python and picked up new skills such as
Development and deployment, critical thinking, keen analysis, etc.

Page 19
 Chapter 9

SHORT REPORT/DESCRIPTION OF PROJECT MADE [IF ANY]

_________________________________________________________________________________________

INTRODUCTION TO PROJECT
A simple application in which a user can maintain a Daily Planner and To- do List.

DESCRIPTION
The planner and to-do list project is a simple yet effective task management application
designed to help users organize their daily activities and stay on top of their schedules.
The planner offers intuitive calendar integration, allowing users to visualize and plan tasks
efficiently.
Additionally, the to-do list feature supports task prioritization and progress tracking, enabling
users to mark completed tasks and track their productivity. With its user-friendly interface and
comprehensive features, this project ensures users stay organized and achieve their goals with
ease.

Page 20
 OUTPUT
i) Entry page

ii) CALENDAR and PLANNER Page

Planner & Calendar

2023

My birthday!!

Page 20
iii) To-Do List
To do list

To-DO-List

? Study

? Complete my project

F Thankyou!

iv) Database file in Juupyter notebook

event.txtw a few seconds ago

File Edit View Lang u age

@ 5 - @B
B::L w1h d ay ! !
ei ei

Page 21
Conclusion & Future Scope:
The
Future Scope:
In the future, the project can be expanded to include user accounts, cloud sync, reminders,
collaboration features, data analytics, gamification elements, mobile app development, and
integration with productivity tools for enhanced functionality and user experience.

Page 22
 Chapter 10

SPECIAL / CHALLENGING EXPERIENCES ENCOUNTERED DURING

TRAINING
_________________________________________________________________________

While Python is a versatile and widely-used language for data science, it does come with its
set of challenges. Some of the common challenges faced while doing data science in Python
include:

1. Performance: Python, being an interpreted language, can sometimes be slower compared

to compiled languages like C++ or Java. This can be a challenge when dealing with large
datasets or complex computations, especially in real-time or high-performance computing
scenarios. However, there are ways to mitigate this issue, such as using optimized libraries
like NumPy, Cython, or utilizing parallel processing techniques.

2. Memory Management: Python's memory management can sometimes be inefficient, leading

to high memory usage, especially when handling large datasets. It may cause memory errors or
slow down the performance of the code. Data scientists need to be mindful of memory usage
and consider memory optimization strategies to avoid these issues.

3. Lack of Native Support for GPU: While Python has libraries like TensorFlow and
PyTorch that provide GPU support for deep learning, the language itself lacks native support for
GPU computing. As a result, some compute-intensive operations might not be as efficiently
executed on a CPU compared to a GPU. However, libraries like TensorFlow and PyTorch
allow data scientists to leverage GPU capabilities effectively.

4. Data Security and Privacy: Data science projects often involve sensitive data, and ensuring
data security and privacy can be challenging. Python's open-source nature might raise
concerns about the security of third-party libraries used in projects. It is essential to
implement secure data handling practices, avoid storing

Page 23
sensitive information in plain text, and follow industry best practices for data protection.

5. Integrating with Legacy Systems: In many real-world scenarios, data science projects need
to integrate with existing legacy systems or databases. Python's integration capabilities are
good, but compatibility issues might arise when dealing with proprietary systems or older
technologies. Data scientists may need to invest effort in bridging the gap between Python and
these systems.

6. Lack of Standardization: Python's open-source ecosystem offers a wide range of libraries

and tools for data science, but the lack of standardization can be a challenge. Different libraries
might have varying APIs, which can make code maintenance and collaboration complex. Using
well-established libraries and adhering to coding best practices can help mitigate this
challenge.

7. Interpretability of Models: Some machine learning models, especially complex deep

learning models, are inherently difficult to interpret and explain. While Python has libraries
for model interpretability, understanding and debugging such models can be challenging,
especially in critical applications where model explainability is crucial.

Page 24
 References / Bibliography
_____________________________________________________________________________________

1) Sofcon-Data-science: https://www.sofcontraining.com/best-data-science- training-

institute.htm

2) SOFCON official site : https://www.sofcontraining.com/

3) Anaconda download: anaconda.com/download

Page 25
Industrial Training
Weekly Diary

Weekly Diary

For

Industrial Training

At

Name of Industry: Sofcon India Private Limited

From: 07/06/2023 To: 21/07/2023

Name of supervisor: SHUBHAM SHARMA

Designation of Supervisor: Branch Manager

Name of the Student: Sonali Amit Patki Enrollment No: 2101410243

Branch of Engineering: Computer Engineering

Name of Polytechnic: All India Shri Shivaji Memorial Society's Polytechnic Pune

(Special instructions to studcnts:

1) Write tlow n the tlaily acti i ity on the same days
2) Make note of the important actual activity/ies only.
3) Summarize at the weekend
4) Add extra sheets if needed for daily or weekly activity repor
Industrial Training Weekly Diary

Week 1: From 07.06.2023 To 16.06.2023

Expected Work:
i. Study of organization chart of’ industry/plant with responsibilities of the different posts
ii. General study of industry, its location, its history anal its product range, its size, number of employees,its
turnover etc.

Day Activities carried out

1 Introduction of the company What is

Data Science?
Language for data science

2 introduction to python Installation

of python and IDE

3 variables, data types and operators in python

4 tokens, keywords, identifiers, literals in python

5 string and tuple in python

6 Revision of above topics

Weekly Summarization of the above activities:

In the 1st Week I leaned the basic things which are variables, data
types,tokens,keyword etc., this topics are the base of python programing

Signature of Student: ........................ Signature of Industrial Supervisor..................

Signature of Mentor:..................

Maharashtra State Board of technical

Education
 Industrial Training Weekly Diary

Week 2: From 19.06.2023 To 23.06.2023

Expected Work: Study of layout and specifications of major machines, equipments and raw
materials/components used.

Day Activities carried out

1 list, dictionary and set in python

2 task on string and tuple

3 task on list, dictionary and set

4 decision making in python

5 task on decision making statements

6 Sloved some List,dictionary tuples based problem

Weekly Summarization of the above activities:

In the 2nd Week I learned the some Basic Data Structure in python which are
tuple,list,Dictionary,set etc. this data structure can be used in day to day life .
And 2nd topic is decision making that helps to understand programming language

Signature of Student: ........................ Signature of Industrial Supervisor..................

Signature of Mentor:....................

Maharashtra State Board of technical

Education
Industrial Training Weekly Diary

Week 3 : From 26.06.2023 To 30.06.2023

Expected Work: Study of the work assigned / study of the departmental work, the databases,
software in which work is done, internally deployed software etc.

Day Activities carried out

1 python loops Loop

control statements

2 task on loops and control statements

3 Functions in python

4 user define functions arguments and

parameters

5 pass keyword and recursion

6 Revision of above topics

Weekly Summarization of the above activities:

Signature of Student: ........................ Signature of Industrial Supervisor..................

Signature of Mentor:....................

Maharashtra State Board of technical Education

 Industrial Training Weekly Diary

Week 4: : From 03.07.2023 To 07.07.2023

Expected Work:
In the duration of 3rd week I learned various different types for loops. Which helps us to
avoid the rewriting specify code . and 2nd topic is function. Function uses to divide the
program into piece of code. Which helps to understand program very quickly .
Study of the testing process, methods used for testing, study of the Quality assurance
aspects that are considered.

Day Activities carried out

1 list as an array lambda

2 practice exercise

3 various Oop's concepts in python

4 Python Inheritance Encapsulation Polymorphism

5 Constructors

6 Revision of above topics

Weekly Summarization of the above activities:

In the duration of 4th week, I studied the amazing topics that is Encapsulation and
polymorphism. The Encapsulation is used to wrapped data and code together.
And the polymorphism used with the loop's concepts. It is commonly used in function
overriding concepts.

Signature of Student: ........................ Signature of Industrial Supervisor..................

Signature of Mentor:....................

Maharashtra State Board of technical Education

 Industrial Training Weekly Diary

Week 5: From 10.07.2023 To 14.07.2023

Expected Work:
Study of maintenance and safety practices in the industry, study of preventive measures
applied.

Day Activities carried out

multiple objects and classes

2 overloading and overriding

3 tasks on loop's

4 Libraries in Python NumPy

5 Pandas

6 Revision of above topics

Weekly Summarization of the above activities:

In Duration of 5th week , I studied how to create multiple object of

c1ass,overloading and overriding concepts, Libraries in python.

Signature of Student: ........................ Signature of Industrial Supervisor..................

Signature of Mentor:....................

Maharashtra State Board of technical Education

Industrial Training weekly Diary

Week 6: From 17.07.2023 To 21.07.2023

Expected Work: Report Writing

Day Activities carried out

1 Matplotlib

2 task on libraries

3 Tkinter

4 work on project

5 Work on project

6 presentation of project

Weekly Summarization of the above activities:

In the duration of 6th week in studied the last python library, and then I worked on my
final project. Which is Planner and calendar with To-Do List.

Signature of Student: ........................ Signature of Industrial Supervisor..................

Signature of Mentor:..................

Maharashtra State Board of technical Education

 ALL INDIA SHRI SHIVAJI MEMORIAL SOCIETY’S POLYTECHNIC, PUNE
DEPARTMENT OF COMPUTER ENGINEERING

Attendance sheet for In-plant Industrial Training Summer-2023

Class:TYCO-A
In-plant Industrial Trainingduration: 06 Weeks
Name of Industry:Sofcon India Private Limited Pune
Date: From:07/06/2023 To: 22/07/2023

Sr. Enrollme
Name of Day1 Day Day Day Day Day Day Day Day Day Day Day Day Day Day Day Day Day
No nt
. No. Student 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
1. 210141024 Sonali Amit P P P P P P P P P P P P A P P P P P
3 Patki
Date 07/6 08/6 09/6 10/6 12/6 13/6 14/6 15/6 16/6 17/6 19/6 20/6 21/6 22/6 23/6 24/6 26/6 27/6
Sign of Industry Supervisor

Sign of Faculty Mentor

Sr. Enrollmen
Name of Day1 Day Day Day Day Day Day Day Day Day Day Day Day Day Day Day Day Day
No t
. No. Student 9 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
1. Sonali Amit P P P P P A A P P P A P P A A P P P
2101410243 Patki
Date 28/06 29/6 30/6 01/7 03/7 04/7 05/7 06/7 07/7 08/7 10/7 11/7 12/7 13/7 14/7 15/7 17/7 18/7
Sign of Industry Supervisor

Sign of Faculty Mentor

Total Days Attended: 31/ 36