[FIXED] How to create a line plot in python, by importing data from excel and using it to create a plot that shares a common X-Axis?

Issue

Trying to create a plot using Python Spyder. I have sample data in excel which I am able to import into Spyder, I want one column ('Frequency') to be the X axis, and the rest of the columns ('C1,C2,C3,C4') to be plotted on the Y axis. How do I do this? This is the data in excel and how the plot looks in excel (https://i.stack.imgur.com/eRug5.png) , the plot and data

This is what I have so far . These commands below (Also seen in the image) give an empty plot.

data = data.head()

#data.plot(kind='line', x='Frequency', y=['C1','C2','C3','C4'])

df = pd.DataFrame(data, columns=["Frequency","C1", "C2","C3","C4"])

df.plot(x = "Frequency",y=["C1", "C2","C3","C4"])

Solution

import pandas as pd
import matplotlib.pyplot as plt


path = r"C:\Users\Alisha.Walia\Desktop\Alisha\SAMPLE.xlsx"
data = pd.read_excel(path)

#df = pd.DataFrame.from_dict(data)
#print(df)
#prints out data from excl in tabular format

dict1 = (data.to_dict()) #print(dict1)


Frequency=data["Frequency "].to_list() #print (Frequency)

C1=data["C1"].to_list() #print(C1)
C2=data["C2"].to_list() #print(C2)
C3=data["C3"].to_list() #print(C3)
C4=data["C4"].to_list() #print(C4)


plt.plot(Frequency,C1)
plt.plot(Frequency,C2)
plt.plot(Frequency,C3)
plt.plot(Frequency,C4)


plt.style.use('ggplot')
plt.title('SAMPLE')
plt.xlabel('Frequency 20Hz-200MHz')
plt.ylabel('Capacitance pF')
plt.xlim(5, 500)
plt.ylim(-20,20)
plt.legend()

plt.show()

Answered By - User-1512