> For the complete documentation index, see [llms.txt](https://docs.consoleflare.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.consoleflare.com/projects/data-analytics-project/solution.md).
# Solution
## Import Necessary Libraries
```python
import pandas as pd
```
## # Reading all the Files:
### Reading Order Report:
```python
CX_order_report = pd.read_excel("COURIER DATA/Company X - Order Report.xlsx")
CX_order_report.head()
```
### Reading Company Invoice
```python
CC_invoice = pd.read_excel(r"COURIER DATA/Courier Company - Invoice.xlsx")
CC_invoice.head()
```
### Reading SKU Master:
```python
CX_SKU_Master = pd.read_excel(r"COURIER DATA/Company X - SKU Master.xlsx")
CX_SKU_Master.head()
```
### Reading Courier Rates:
```python
CC_Rates = pd.read_excel(r"COURIER DATA/Courier Company - Rates.xlsx")
CC_Rates.head()
```
### Reading Pincode Zones:
```python
CX_Pincode_Zones = pd.read_excel(r"COURIER DATA\Company X - Pincode Zones.xlsx")
CX_Pincode_Zones.head()
CX_Pincode_Zones
```
```python
# renaming all the columns as x as client x and cc as courier company
```
### Renaming all the columns as x as client x and cc as courier company
```python
CX_Pincode_Zones.rename(columns = {'Zone':'zone_X'}, inplace = True)
CX_Pincode_Zones
```