/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

5 votes330 views1 answer
Datetime one week ago python
Python
0 vote353 views2 answers
Matplotlib colormap transparent white to black
Python
18 votes318 views6 answers
Python get last element of array
Python
17 votes315 views2 answers
Count lines in file python
Python
0 vote319 views1 answer
No limit row pandas
Python
0 vote350 views1 answer
Username python system
Python
6 votes317 views3 answers
Python console pause
Python
3 votes307 views1 answer
Nlargest
Python
73 votes296 views6 answers
Python reverse a string
Python
4 votes324 views2 answers
Python press any key to continue
Python