Python Programming In 30 Days Day -14

Python
Programming
In 30 Days

Day -14


What is Pandas

Pandas is an open Source data analysis library written in python.

Data Analysis libraries: will learn to use Pandas, Numpy and Scipy libraries to work with a sample dataset.

Pandas is used for Data Analytics most in python.




Pandas Data Structure

Pandas has two types of Data Structures:

Series – Its one dimension array and part of data structure. Eg df [‘a1’]


Data Frame – Its two dimension array and contains multiple series. Eg df

# Create dataFreme with dictonery
import pandas as pd
data={
'Id' : [101,102,103,104,105,106],
'Name' : ['Arshad','Pankaj','Lokesh','Saurabh','Abhinav','Niraj'],
'Score' : [80,90,99,95,96,79]

}
df=pd.DataFrame(data)
df

# to_csv is used create csv file.
df.to_csv('/folders/myfolders/Score.csv')

# read_csv is used for read csv external file.
new1=pd.read_csv('/folders/myfolders/records.csv')
new1

import numpy as np
new = pd.DataFrame(np.random.rand(10,5), index=np.arange(10))
new


#Sort rows or index in decending order
new.sort_index(axis=0 , ascending=False)


#Sort Columns in decending order
new.sort_index(axis=1 , ascending=False)

# is used for rename columns name
new.index = list("ABCDEFIJKI")
new

#print two rows from starting from selected columns
new.loc[[1,2], ['A','B']]

#print two rows from starting
new.loc[[1,2],:]

# inplace is used for drop the columns from original data
new=new.drop(['B'], axis=1, inplace=True)
new