pandas - 行操作

import pandas as pd

operation of line of case

sort line by index

‘’’#语法
df.sort_index(
level:specify index by name or Sequence number
ascending = True:ascending sequence
inplace = False
na_position = ‘last’:(first/last)
)
‘’’

df1 = pd.read_csv('123.csv',encoding='utf-8')
df1.set_index(['地址','店家'],inplace=True)

print(df1.sort_index(level='地址',ascending = False))

sort line by var value

‘’’# 语法
df.sort_values(
by:specify var name to sort,multi-line
ascending:True
inplace = False
na_position = ‘last’
)

print(df1.sort_values(['名次',],ascending = True))

filter

Essential principle (df灌入True与False序列)

sellist = [True,False,True]
print(df1.iloc[sellist])

filter by Absolute position :df.iloc,suitable for row and columns

print(df1.iloc[0:3])
print(df1