#Pgm to read the downloaded .csv files
#File downloaded - All India Pin codes from the website - data.gov.in
setwd=setwd("C:\\Users\\JyothiAP\\Documents\\Collabera_BA with R\\R codes")
library(data.table)
library(readr)
#Read the dowloaded csv file
data1=read_csv("all_india_PO_list.csv")
str(data1)
## Classes 'tbl_df', 'tbl' and 'data.frame': 154797 obs. of 13 variables:
## $ officename : chr "Achalapur B.O" "Ada B.O" "Adegaon B.O" "Adilabad Collectorate S.O" ...
## $ pincode : int 504273 504293 504307 504001 504001 504251 504273 504251 504309 504201 ...
## $ officeType : chr "B.O" "B.O" "B.O" "S.O" ...
## $ Deliverystatus : chr "Delivery" "Delivery" "Delivery" "Non-Delivery" ...
## $ divisionname : chr "Adilabad" "Adilabad" "Adilabad" "Adilabad" ...
## $ regionname : chr "Hyderabad" "Hyderabad" "Hyderabad" "Hyderabad" ...
## $ circlename : chr "Andhra Pradesh" "Andhra Pradesh" "Andhra Pradesh" "Andhra Pradesh" ...
## $ Taluk : chr "Asifabad" "Asifabad" "Boath" "Adilabad" ...
## $ Districtname : chr "Adilabad" "Adilabad" "Adilabad" "Adilabad" ...
## $ statename : chr "TELANGANA" "TELANGANA" "TELANGANA" "TELANGANA" ...
## $ Telephone : chr NA NA NA "08732-226703" ...
## $ Related Suboffice : chr "Rechini S.O" "Asifabad S.O" "Echoda S.O" NA ...
## $ Related Headoffice: chr "Mancherial H.O" "Mancherial H.O" "Adilabad H.O" "Adilabad H.O" ...
head(data1)
## officename pincode officeType Deliverystatus divisionname
## 1 Achalapur B.O 504273 B.O Delivery Adilabad
## 2 Ada B.O 504293 B.O Delivery Adilabad
## 3 Adegaon B.O 504307 B.O Delivery Adilabad
## 4 Adilabad Collectorate S.O 504001 S.O Non-Delivery Adilabad
## 5 Adilabad H.O 504001 H.O Delivery Adilabad
## 6 Agm Colony S.O 504251 S.O Non-Delivery Adilabad
## regionname circlename Taluk Districtname statename
## 1 Hyderabad Andhra Pradesh Asifabad Adilabad TELANGANA
## 2 Hyderabad Andhra Pradesh Asifabad Adilabad TELANGANA
## 3 Hyderabad Andhra Pradesh Boath Adilabad TELANGANA
## 4 Hyderabad Andhra Pradesh Adilabad Adilabad TELANGANA
## 5 Hyderabad Andhra Pradesh Adilabad Adilabad TELANGANA
## 6 Hyderabad Andhra Pradesh Bellampalle Adilabad TELANGANA
## Telephone Related Suboffice Related Headoffice
## 1 <NA> Rechini S.O Mancherial H.O
## 2 <NA> Asifabad S.O Mancherial H.O
## 3 <NA> Echoda S.O Adilabad H.O
## 4 08732-226703 <NA> Adilabad H.O
## 5 08732-226738 <NA> <NA>
## 6 08735-222138 <NA> Mancherial H.O
# Remove column(#7) name-Circle name as the content is same as Statename
data2=data1[-7]
#Remove column(#8) name-District name as the content is same as Division name
final_pin=data2[-8]
head(final_pin)
## officename pincode officeType Deliverystatus divisionname
## 1 Achalapur B.O 504273 B.O Delivery Adilabad
## 2 Ada B.O 504293 B.O Delivery Adilabad
## 3 Adegaon B.O 504307 B.O Delivery Adilabad
## 4 Adilabad Collectorate S.O 504001 S.O Non-Delivery Adilabad
## 5 Adilabad H.O 504001 H.O Delivery Adilabad
## 6 Agm Colony S.O 504251 S.O Non-Delivery Adilabad
## regionname Taluk statename Telephone Related Suboffice
## 1 Hyderabad Asifabad TELANGANA <NA> Rechini S.O
## 2 Hyderabad Asifabad TELANGANA <NA> Asifabad S.O
## 3 Hyderabad Boath TELANGANA <NA> Echoda S.O
## 4 Hyderabad Adilabad TELANGANA 08732-226703 <NA>
## 5 Hyderabad Adilabad TELANGANA 08732-226738 <NA>
## 6 Hyderabad Bellampalle TELANGANA 08735-222138 <NA>
## Related Headoffice
## 1 Mancherial H.O
## 2 Mancherial H.O
## 3 Adilabad H.O
## 4 Adilabad H.O
## 5 <NA>
## 6 Mancherial H.O