I have the following code: -
2. How do I find the maximum profit in column H called 'Profit'?
Thanks in advance.
import pandas as pd out = pd.read_excel(io = "E:/Folder/Company Financials.xlsx", sheet_name = "Sales", usecols = "A:J", skiprows = 5) print(out)1. How do I change the code so that the data is copied over to a new Excel file but being retained in the original file?
2. How do I find the maximum profit in column H called 'Profit'?
Thanks in advance.