import pandas as pd
df = pd.read_csv('/sample.txt', header=None, skiprows=[0],skipfooter=1, delimiter = '|', names=["COL1","COL2","COL3"])
#ds = df.iloc[1:].iloc[:-1]
spark.createDataFrame(df.astype(str)).createOrReplaceTempView('BaseCode')
Code to read csv data with columns and skip top,bottom rows Print
Modified on: Wed, 15 Dec, 2021 at 5:30 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.