import pandas as pd

import databricks.koalas as ks

df = pd.read_csv('/sample.csv', engine='python', sep='|', skiprows=[0], skipfooter=2)

df.columns = df.columns.str.replace('[., ,/,-]','_')

out = ks.from_pandas(df)

out1 = out.to_spark()

out1.createOrReplaceTempView('BaseCode')