Pandas

06 – String Operations Pands String Operations¶Pandas provides a set of string functions which make it easy to operate on string data. Most importantly, these functions ignore (or exclude) missing/NaN values. lower(): Converts strings in the Series/Index to lower case. upper(): Converts strings in the Series/Index to upper case. len(): …

05 – Descriptive Statistics and Stats Operations 1. Descriptive Statistics for Pandas DataFrame¶ In [1]: import pandas as pd import numpy as np In [2]: data = {'Name':pd.Series(['Akshay','Rajat','Robin','Kapil','James','Cyril']),'Age':pd.Series([25,26,29,27,23,21]),'Rating':pd.Series([4.23,2.35,1.56,3.20,4.62,3.99])} df = pd.DataFrame(data) df Out[2]: Name Age Rating 0 Akshay 25 4.23 1 Rajat 26 2.35 2 Robin 29 1.56 3 Kapil 27 3.20 …

04- Indexing-Selection-Filtering in Pandas Indexing-Selection-Filtering in Pandas¶ In [1]: #import the libraries import pandas as pd import numpy as np 1. Series Indexing¶ In [2]: a=pd.Series([14,68,46,24,83],index=["a","b","c","d","e"]) a Out[2]: a 14 b 68 c 46 d 24 e 83 dtype: int64 selecting the value at index d.¶ In [3]: a['d'] Out[3]: 24 You can …

03- DataFrame DataFrames¶A Data frame is a two-dimensional data structure, i.e., data is aligned in a tabular fashion in rows and columns. Features of DataFrame Potentially columns are of different types Size : Mutable Labeled axes (rows and columns) Can Perform Arithmetic operations on rows and columns A pandas DataFrame …

02- Series Data Structure Series Data Structure¶ A Series is a one-dimensional object that can hold any data type such as integers, floats and strings, Python Objects and etc. pandas.Series( data, index, dtype, copy) data: data takes various forms like ndarray, list, constants index: Index values must be unique and …

Pandas is a Python library used for working with data sets. It has functions for analyzing, cleaning, exploring, and manipulating data. The name “Pandas” has a reference to both “Panel Data”, and “Python Data Analysis” and was created by Wes McKinney in 2008. It provides special data structures and operations …