Pandas에서 원하는 행, 열 추출하기

 

import natsort, pandas

N = 20
path_range = [f"P_{i}" for i in range(N+1)]
value_range = [f"V_{j}" for j in range(N+1)]

(paths, 
 values) = (natsort.natsorted(path_range),
            natsort.natsorted(value_range))

df = pandas.DataFrame({"P": paths,
                       "V": values})

# 열 추출, column
"""
series
"""
path_column_series = df.P
value_column_series = df.V

"""
list
"""
path_column_list = df.P.tolist() 
value_column_list = df.V.tolist() 

"""
numpy
"""
path_column_numpy = df.P.to_numpy()
value_column_numpy = df.V.to_numpy()

"""
모든 데이터 numpy로 변환
"""
numpy_data = df.values


# 행 추출, row
filterd_rows_df = df.loc[[0, 2, 18], ["P", "V"]]