Date         Query
29-03-2019   SELECT * FROM tableN WHERE ..
30-03-2019   SELECT * FROM ... JOIN ... ON ...WHERE ..
....         ....
20-05-2019   SELECT ...

date        tableName                     attributeName
29-03-2019  [tableN]                      [attM]
30-03-2019  [tableA as A,tableC as C]     [A.attB, C.attD]
....        ...                            ...
20-05-2019  [tableF]                      [attG]

def getTableAttribute(dF):
    df2 = dF.copy()
    df2["tableName"] = df2["Query"].apply(getTable)
    df2["attributeName"] = df2["Query"].apply(getCol)
    df2.drop("Query", axis=1, inplace=True)
    print("Donen")
    return df2