[PYTHON] Pandas.DataFrame Tips (Matrix Manipulation)

Create an empty data frame

sample.py

    import pandas as pd

    #Column name setting
    cols = ['id', 'name']
    #Create an empty data frame
    df = pd.DataFrame(index=[], columns=cols)
    #Data content creation
    data = [1, 'test']
    #Add data to the data frame
    df.loc[len(df)] = data
    print(df)
    '''
      id  name
    0  1  test
    '''

Add multiple rows to a data frame using a list

sample.py

    #Column name setting
    cols = ['id', 'name']
    #Create an empty data frame
    df = pd.DataFrame(index=[], columns=cols)
    #Create a list
    id_list = [1, 2, 3, 4, 5]
    name_list = ['Taro', 'Hanako', 'Akira', 'Hitomi', 'Kenta']
    #Create data frame for concatenation
    df_tmp = pd.DataFrame({'id': id_list ,'name': name_list})
    #Connect data frames vertically
    df = df.concat([df, df_tmp])
    print(df)
    '''
      id    name
    0  1    Taro
    1  2  Hanako
    2  3   Akira
    3  4  Hitomi
    4  5   Kenta
    '''