Sydney Shall wrote: > On 28/09/2017 11:46, Peter Otten wrote: >> larrystale...@comcast.net wrote: >> >>> I am very new to Python and appreciate the input as I was able to fully >>> install Python with all needed libraries (i.e., numpy, pandas, etc.). >>> However, I now have an application question in needed to construct a 2D >>> Histogram. >>> >>> Basically, I have an Excel file that includes three columns: >>> Column 1 - Gender (Male or Female) >>> Column 2 - Height (in inches) >>> Column 3 - Hand Span (in inches) >> >> I have yet to grok your code samples, but my feeling is that your >> approach is too low-level. Do you mean something like >> >> http://matplotlib.org/examples/pylab_examples/hist2d_demo.html >> >> by "2d histograms"? That would require very little code written by >> yourself: >> >> import pandas as pd >> from matplotlib import pyplot >> >> filename = "size.xls" >> sheetname = "first" >> >> data = pd.read_excel(filename, sheetname) >> >> for index, sex in enumerate(["female", "male"], 1): >> pyplot.figure(index) >> subset = data[data["Gender"] == sex] >> pyplot.hist2d(subset["Height"].values, subset["Hand Span"].values) >> >> pyplot.show() > I have a similar problem, but my data is not in excel but is in > OpenOffice "Spreadsheet', but not in "Database". > > My question is can I use a similar simple procedure as that given by > Peter Otten.
There doesn't seem to be direct support for the ods file format in pandas. Your easiest option is to open the file in OpenOffice and save as xls or csv. If you don't want to go that route you can install a library that can read ods files. With https://pypi.python.org/pypi/pyexcel-ods/0.3.1 the above example should work after the following modifications: import pandas as pd from matplotlib import pyplot import pyexcel_ods def read_ods(filename, sheetname): table = pyexcel_ods.read_data(filename)[sheetname] return pd.DataFrame(table[1:], columns=table[0]) filename = "size.ods" sheetname = "first" data = read_ods(filename, sheetname) for index, sex in enumerate(["female", "male"], 1): pyplot.figure(index) subset = data[data["Gender"] == sex] pyplot.hist2d(subset["Height"].values, subset["Hand Span"].values) pyplot.show() _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
