I want to plot the line graph with so many lines. I found the below basic commend to plot 1 line.

```
import matplotlib.pyplot as plt
location_3='C:\\Users\\Poon\\Downloads\\20211014_SBS_BEMS\\1043 final.csv'
csvfiles_3=glob.glob(location_3)
df7=pd.DataFrame()
for file_new_3 in csvfiles_3: 
    df7=pd.read_csv(file_new_3,skiprows=[0])
    print(df7)
    ax=plt.plot(df7.iloc[:, 1],df7.iloc[:, 2],'g')

```

But I need to plot more than 100 lines. Is there a faster way? Here are some of my data set in excel. There is more column than I show.

```
19/5/2019 0:00  237 64.93   82.35   16.15   46.88   18.11   148.3115
19/5/2019 1:00  237.2667    64.93   82.35   16.15   46.88   18.11   148.3295
19/5/2019 2:00  238 64.93   82.35   16.15   46.88   18.11   148.348
19/5/2019 3:00  238 64.93   82.35   16.15   46.88   18.11   148.3672
19/5/2019 4:00  238 64.93   82.35   16.15   46.88   18.11   148.4432
19/5/2019 5:00  238 64.93   82.35   16.15   46.88   18.11   148.7437
19/5/2019 6:00  238 64.93   82.35   16.15   46.88   18.11   149.064
19/5/2019 7:00  238 64.93   82.35   16.15   46.88   18.11   149.3825
19/5/2019 8:00  238 64.93   82.35   16.15   46.88   18.11   149.7037
19/5/2019 9:00  238.7833    64.93   82.35   16.15   46.88   18.11   150.0222
19/5/2019 10:00 239 64.93   82.35   16.15   46.88   18.11   150.3422
19/5/2019 11:00 239 64.93   82.35   16.15   46.88   18.11   150.6617
19/5/2019 12:00 239 64.93   82.35   16.15   46.88   18.11   150.9813
19/5/2019 13:00 239 64.93   82.35   16.15   46.88   18.11   151.3018
19/5/2019 14:00 239 64.93   82.35   16.15   46.88   18.11   151.6213
19/5/2019 15:00 239 64.93   82.35   16.15   46.88   18.11   151.94
19/5/2019 16:00 239.4167    64.93   82.35   16.15   46.88   18.11   152.2615
19/5/2019 17:00 240 64.93   82.35   16.15   46.88   18.11   152.5812
19/5/2019 18:00 240 64.93   82.35   16.15   46.88   18.11   152.8295
19/5/2019 19:00 240 64.93   82.35   16.15   46.88   18.11   152.8608
19/5/2019 20:00 240 64.93   82.35   16.15   46.88   18.11   152.8797
19/5/2019 21:00 240 64.93   82.35   16.15   46.88   18.11   152.8962
19/5/2019 22:00 240 64.93   82.35   16.15   46.88   18.11   152.9148
19/5/2019 23:00 240.05  64.93   82.35   16.15   46.88   18.11   152.9337
20/5/2019 0:00  241 64.93   82.35   16.15   46.88   18.11   152.9508

```

So What I want is the x-axis to be the date, and Y-axis is column 2, then 3,4....until the end.

Moreover, the x-axis needs to reduce the number of plot ticks. Now there are too many plot ticks. How can I reduce them to "only year"? For example, there should be only 2019,2020,2021,2022.

Thanks a lots guys for your help.