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 duplication, compression 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.
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 .
Now we will follow our CGPAP
Step 2:Create Data
Here we our own data and write in a ecel file through ‘to_excel()‘.
Step 3: Get Data
Here we will read the excel file through ‘read_excel()‘
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.
Step 5: Analyze Data
Now we are going to find and outliers and analyze data through graphs.
Step 6:Present Data
Now we are presenting information in the form of graphs.First we represent maximum customer count
We have completed our mission and we will learn further in future post.