/Python/Pandas slicing from one column to another

Pandas slicing from one column to another

# slice from 'foo' to 'cat' by every 2nd column
df.loc[:, 'foo':'cat':2]
# foo quz cat

# slice from the beginning to 'bar'
df.loc[:, :'bar']
# foo bar

# slice from 'quz' to the end by 3
df.loc[:, 'quz'::3]
# quz sat

# attempt from 'sat' to 'bar'
df.loc[:, 'sat':'bar']
# no columns returned

# slice from 'sat' to 'bar'
df.loc[:, 'sat':'bar':-1]
sat cat ant quz bar

# slice notation is syntatic sugar for the slice function
# slice from 'quz' to the end by 2 with slice function
df.loc[:, slice('quz',None, 2)]
# quz cat dat

# select specific columns with a list
# select columns foo, bar and dat
df.loc[:, ['foo','bar','dat']]
# foo bar dat

Source: stackoverflow.com

Python - row slice dataframe by number of rows

df.iloc[[1, 5]]                                               # Get rows 1 and 5
df.iloc[1:6]                                                  # Get rows 1 to 5 inclusive
df.iloc[[1, 5], df.columns.get_loc('Shop')]                   # Get only specific column
df.iloc[[1, 5], df.columns.get_indexer(['Shop', 'Category'])] # Get multiple columns

Source: stackoverflow.com

Similar codes

1 vote196 views1 answer
How to get index of week in list in python
Python
-1 vote217 views1 answer
Class views django slug
Python Django
10 votes205 views1 answer
Python check if number is float or int
Python
26 votes191 views5 answers
How to square root in python
Python
0 vote201 views1 answer
Dataframe show to semicolon python
Python
2 votes219 views4 answers
Python repr()
Python
1 vote227 views1 answer
Import "django.core.urlresolvers" could not be resolved
Python Django
0 vote183 views1 answer
Python set remove multiple elements
Python
1 vote188 views1 answer
How to print something with tkinter
Python
0 vote193 views1 answer
Use mark down with flask
Python