ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • Pandas에서 원하는 행, 열 추출하기
    Pandas 2021. 12. 6. 15:24

     

    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"]]

    댓글

Designed by Tistory.