• Roscoe

    @stephen

    Thanks for the help. I managed to plot the data (I just wanted to chart the plot in Pythonista). I used the following code.

    import os
    import matplotlib.pyplot as plt 
    import openpyxl 
    from openpyxl import cell, chart, chartsheet, comments, compat, constants, descriptors, drawing, formatting
    
    wb = openpyxl.load_workbook('/private/var/mobile/Containers/Shared/AppGroup/29254C8A-D386-4CDC-B278-AAA57C080F82/Pythonista3/Documents/Prac4.xlsx')
    sheet = wb['Tstat']
    
    for i in range(1,sheet.max_row,1):
        x1data = sheet.cell(row=i,column=1).value
        y1data = sheet.cell(row=i,column=2).value
        x2data = sheet.cell(row=i,column=4).value
        y2data = sheet.cell(row=i,column=5).value
        x3data = sheet.cell(row=i,column=7).value
        y3data = sheet.cell(row=i,column=8).value
        plt.plot(x1data,y1data,'r^',x2data,y2data,'bo',x3data,y3data,'mv') 
        
    plt.show() 
    

    Although I could only show points on the plot and couldn’t create a line.

    posted in Pythonista read more
  • Roscoe

    I forgot to state that I am working on an iPad using Pythonista.

    posted in Pythonista read more
  • Roscoe

    Thanks for the quick reply. I am still struggling, i am getting a file not found error. This is my script so far.

    import os
    import numpy as np
    import matplotlib.pyplot as plt
    import openpyxl

    wb = openpyxl.load_workbook('Prac4.xlsx')
    sheet = wb['Tstat']

    posted in Pythonista read more
  • Roscoe

    Hi, I am new to python with some coding experience. I am trying to write a Pythonista script to read excel data from two columns and plot one of the columns data on the x-axis and the other columns data on the y-axis.

    posted in Pythonista read more
Internal error.

Oops! Looks like something went wrong!