[Solved] Plotting from excel to python with pandas

Question

Check out these packages/ functions, you’ll find some code on these websites and you can tailor it to your needs.

Some useful codes:

import pandas as pd
df = pd.read_excel('your_file.xlsx')

Code above reads an excel file to python and keeps it as a DataFrame, named df.

Matplotlib

import matplotlib.pyplot as plt

plt.plot(df['column - x axis'], df['column - y axis'])
plt.savefig('you_plot_image.png')
plt.show()

This is a basic example of making a plot using matplotlib and saving it as your_plot_image.png, you have to replace column - x axis and column - y axis with desired columns from your file.

For cleaning data and some basics regarding DataFrames have a look at this package: Pandas

Accepted Answer