Overview:

In this post we are going to learn how to read and write file in excel through Pandas functions.We will learn how to remove irregularities and duplicationcompression of data and forecasting the next year customer count(as per out data).After all that we will try to analyze data loaded from excel files to extract information and represent the information in presentable form.

Mission: 

Analyze the  data(here data set is of customer count) to get forecast the next year Customer Count and get the pictorial representation of relationship.

Step 1:Import all libraries and functions that will be required .

p2f1

Now we will follow our CGPAP

Step 2:Create Data

Here we our own data and  write in a ecel file through to_excel()‘.

p2f2

p2f5 p2f3

p2f5

Step 3: Get Data

Here we will read the excel file through ‘read_excel()

p2f6

p2f7

Step 4: Prepare Data

As we already know this is the section we start and finish cleaning data.Here we will try to do following:

1.Remove duplicate data.

2.Make sure that data in Upper Case

3.We will use only status=1 data to make data handy

4.Remove any outliers(unnecessary data) if present.

p2f8

p2f9

p2f10

p2f11

p2f12

p2f13

p2f14

Step 5: Analyze Data

Now we are going to find and outliers and analyze data through graphs.

p2f15

p2f16

p2f17

p2f18

p2f19

p2f20

p2f21

p2f22

p2f23

p2f25

p2f26

p2f27

p2f28

p2f29

p2f30

p2f31

p2f32

p2f33p2f34

p2f35


As we have predicted the the next years Customer Count ,now we need to present data.

Step 6:Present Data

Now we are presenting information in the form of graphs.First we represent maximum customer count

p2f36

p2f37

p2f38

p2f39

We have completed our mission and we will learn further in future post.

Advertisements