Skip to main content

Pandas Operations - Unique, Value Counts, Apply, Drop, Columns, Index, Sort Values, Is Null, Pivot Tables - Python

Pandas Operations - Unique, Nunique, Value Counts, Apply, Drop, Columns, Index, Sort Values, Is Null, Pivot Tables
Run the python code here: https://repl.it/@VinitKhandelwal/pandas-operations
import numpy as np
import pandas as pd

df = pd.DataFrame({'col1':[1,2,3,4],'col2':[1111,2222,3333,2222],'col3':['aaa','bbb','ccc','ddd']})
print(df)
print("LIST OF UNIQUE VALUES IN A COLUMN")
print(df['col2'].unique())
print("COUNT OF UNIQUE VALUES IN A COLUMN")
print(df['col2'].nunique())
print("COUNT OF VALUES IN A COLUMN")
print(df['col2'].value_counts())
print("CONDITIONAL SELECTION")
print(df[(df['col1']>2) & (df['col2']<3333)])
print(df['col1']>2)
print("APPLY")
def times2(x):
return x*2
print(df.apply(times2))
print(df['col3'].apply(len))
print("APPLY LAMBDA FUNCTION")
print(df.apply(lambda x: x*3))
print("DROP")
print(df.drop('col1', axis=1))
df.drop('col1', axis=1, inplace=True)
print(df)
df['col1']=[1,2,3,4]
print(df)
print("DEATILS OF COLUMNS AND INDICES")
print(df.columns)
print(df.index)
print("SORT COLUMN")
print(df.sort_values('col2'))
print("IS NULL")
print(df.isnull())
print("PIVOT TABLE")
df = pd.DataFrame({'A':['foo', 'foo', 'foo', 'bar', 'bar', 'bar'], 'B':['one', 'one', 'two', 'two', 'one', 'one'], 'C':['x', 'y', 'x', 'y', 'x', 'y'], 'D':[1,3,2,5,4,1]})
print(df)
df2 = df.pivot_table(values='D', index=['A','B'], columns=['C'])
print(df2)
print("DEATILS OF COLUMNS AND INDICES")
print(df2.columns)
print(df2.index)

OUTPUT

   col1  col2 col3
0     1  1111  aaa
1     2  2222  bbb
2     3  3333  ccc
3     4  2222  ddd
LIST OF UNIQUE VALUES IN A COLUMN
[1111 2222 3333]
COUNT OF UNIQUE VALUES IN A COLUMN
3
COUNT OF VALUES IN A COLUMN
2222    2
1111    1
3333    1
Name: col2, dtype: int64
CONDITIONAL SELECTION
   col1  col2 col3
3     4  2222  ddd
0    False
1    False
2     True
3     True
Name: col1, dtype: bool
APPLY
   col1  col2    col3
0     2  2222  aaaaaa
1     4  4444  bbbbbb
2     6  6666  cccccc
3     8  4444  dddddd
0    3
1    3
2    3
3    3
Name: col3, dtype: int64
APPLY LAMBDA FUNCTION
   col1  col2       col3
0     3  3333  aaaaaaaaa
1     6  6666  bbbbbbbbb
2     9  9999  ccccccccc
3    12  6666  ddddddddd
DROP
   col2 col3
0  1111  aaa
1  2222  bbb
2  3333  ccc
3  2222  ddd
   col2 col3
0  1111  aaa
1  2222  bbb
2  3333  ccc
3  2222  ddd
   col2 col3  col1
0  1111  aaa     1
1  2222  bbb     2
2  3333  ccc     3
3  2222  ddd     4
DEATILS OF COLUMNS AND INDICES
Index(['col2', 'col3', 'col1'], dtype='object')
RangeIndex(start=0, stop=4, step=1)
SORT COLUMN
   col2 col3  col1
0  1111  aaa     1
1  2222  bbb     2
3  2222  ddd     4
2  3333  ccc     3
IS NULL
    col2   col3   col1
0  False  False  False
1  False  False  False
2  False  False  False
3  False  False  False
PIVOT TABLE
     A    B  C  D
0  foo  one  x  1
1  foo  one  y  3
2  foo  two  x  2
3  bar  two  y  5
4  bar  one  x  4
5  bar  one  y  1
C          x    y
A   B
bar one  4.0  1.0
    two  NaN  5.0
foo one  1.0  3.0
    two  2.0  NaN
DEATILS OF COLUMNS AND INDICES
Index(['x', 'y'], dtype='object', name='C')
MultiIndex(levels=[['bar', 'foo'], ['one', 'two']],
           labels=[[0, 0, 1, 1], [0, 1, 0, 1]],
           names=['A', 'B'])

Comments

Popular posts from this blog

Python - Mathematical Functions - Hexadecimal, Binary, Exponential, Absolute, Round

🐍 Some mathematical functions are in-built in python. Here are some of them. Convert Decimal to Hexadecimal hex(246) Output: '0xf6' hex(512) Output: '0x200' 0x is prefix to all hexadecimal numbers in output. The number after 0x is the hexadecimal value. Convert Decimal to Binary bin(1234) Output: '0b10011010010' bin(246) Output: '0b11110110' bin(512) Output: '0b1000000000' Exponential Function pow() function is similar to num1**num2, but it comes useful when you want to execute (num1**num2)%num3. Passing three arguments to pow(), does this. pow(3,4) Output: 81 This works just like 3**4 pow(3,4,5) Output: 1 But this, works equivalent to (3**4)%5. Either of the two ways can be used. At this point I feel (3**4)%5 is better, as anybody reading the code will understand what is being done immediately. While with pow(2,3,4), the person may have to refer to documentation to understand how this function works. Absolute Value The function abs() is used ...

Two Ways of rendering in React Examples

Two Ways of rendering in React Examples 1 - Render twice HTML < div id = "p1" ></ div > < div id = "p2" ></ div > CSS . person { display : inline - block ; margin : 10px ; border : 1px solid # eee ; box - shadow : 0 2px 2px # ccc ; } JAVASCRIPT (Babel) function Person ( props ) { return ( < div className = ' person "> < h1 >{ props . name }</ h1 > < p > Age :{ props . age }</ p > </ div > ); } ReactDOM . render (< Person name = "VK" age = "29" />, document . querySselector ( '#p1' )); ReactDOM . render (< Person name = "HK" age = "28" />, document . querySselector ( '#p2' )); 2 Render all at once HTML < div id = "app" ></ div > CSS . person { display : inline - block ; margin : 1...

Binary Tree Traversal in Python - In Order, Pre Order, Post Order

Binary Tree Traversal in Python - In Order, Pre Order, Post Order Run the code here to see output:  https://repl.it/@VinitKhandelwal/iterative-traversal-of-binary-tree # Node Class to Create Object of Nodes class Node (): def __init__ ( self , value , left= None , right= None ): self .value = value self .left = left self .right = right # Creation of a Binary Tree class BinaryTree (): def __init__ ( self , mylist ): self .mylist = mylist self .root=Node ( None ) for value in self .mylist : self .curr= self .root self ._add ( value ) def _add ( self , value ): if self .curr.value == None : self .curr.value = value else : if self .curr.value > value : if self .curr.left == None : self .curr.left = Node ( value ) else : self .curr = self .curr.left self ._add ( value ) else : if self...