<p dir="ltr">If you don't mind using something that is outside your standard Python distribution, I would recommend the pandas library as Jim suggested. I made a cheat sheet for it that you may like:<br>
<a href="http://nbviewer.jupyter.org/github/pybokeh/jupyter_notebooks/blob/master/pandas/PandasCheatSheet.ipynb">http://nbviewer.jupyter.org/github/pybokeh/jupyter_notebooks/blob/master/pandas/PandasCheatSheet.ipynb</a></p>
<p dir="ltr">Regards,<br>
Daniel</p>
<div class="gmail_quote">On Nov 3, 2015 7:39 PM, <<a href="mailto:jep200404@columbus.rr.com">jep200404@columbus.rr.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">David commented[1]:<br>
<br>
> I'm looking for a program that will ...<br>
<br>
I don't know if a program that does everything you want<br>
already exists. One can make a Python program to do it.<br>
<br>
> ... take a csv or Excel file ...<br>
<br>
Python's csv module groks csv files and<br>
csv-ish Excel files with aplomb.<br>
<br>
> ... and profile the data in it:<br>
> # of rows, ...<br>
<br>
easy<br>
<br>
> ... list of column names, ...<br>
<br>
easy _if_ always done the same way<br>
<br>
> ... worksheet tab (if Excel), ...<br>
<br>
I don't know what that is.<br>
<br>
> ... max and min in a column, ...<br>
<br>
easy<br>
might also play with pandas library<br>
<br>
> ... whether a column has all unique values ...<br>
<br>
easy with sets and len()<br>
<br>
> ... or a histogram of the values (value and count) when there<br>
> are less than <x> unique values (parameter input into program), ...<br>
<br>
not hard if you want text histogram<br>
something ala sort | uniq -c | sort -n can be done in Python<br>
if you need graphics histogram,<br>
matplotlib and maybe ipython notebook/jupyter<br>
<br>
> whether a column is all numeric, all alpha or alpha numeric,<br>
> if numeric then average and median values.<br>
<br>
not hard<br>
<br>
> Thanks! If this isn't the right forum, I apologize in advance.<br>
<br>
The meetup web page and meetup mailing list are mediocre<br>
for technical discussions. Good forums for technical discussions are:<br>
The weekly Python lunches.<br>
The weekly dojos.<br>
COhPy's mailing list[3]<br>
(distinctly different from the meetup mailing list)<br>
cohpy monthly meetings and after meetings<br>
<br>
Also, Stauf's Coffee Roasters in Grandview around 8:30 to 9:15[2]<br>
esp. weekdays<br>
<br>
Also visit <a href="http://cohpy.org" rel="noreferrer" target="_blank">cohpy.org</a>.<br>
<br>
Someone might need to let David know that there is a response<br>
on cohpy's mailing list to his meetup comment.<br>
<br>
[1] <a href="http://www.meetup.com/Central-Ohio-Python-Users-Group/events/226471478/" rel="noreferrer" target="_blank">http://www.meetup.com/Central-Ohio-Python-Users-Group/events/226471478/</a><br>
<br>
[2] Stauf's Coffee Roasters 1277 Grandview Ave<br>
<a href="http://lists.colug.net/pipermail/colug-432/2015-February/003564.html" rel="noreferrer" target="_blank">http://lists.colug.net/pipermail/colug-432/2015-February/003564.html</a><br>
<a href="http://lists.colug.net/pipermail/colug-432/2015-May/003814.html" rel="noreferrer" target="_blank">http://lists.colug.net/pipermail/colug-432/2015-May/003814.html</a><br>
You never know who is going to show up.<br>
Doughnuts from DK Diner and<br>
anything from Thurn's are great lubrication for discussion.<br>
<br>
[3] cohpy's (technical) mailing list<br>
<a href="https://mail.python.org/mailman/listinfo/centraloh" rel="noreferrer" target="_blank">https://mail.python.org/mailman/listinfo/centraloh</a><br>
To get good answers, consider following the advice in the links below.<br>
<a href="http://catb.org/~esr/faqs/smart-questions.html" rel="noreferrer" target="_blank">http://catb.org/~esr/faqs/smart-questions.html</a><br>
<a href="http://web.archive.org/web/20090627155454/www.greenend.org.uk/rjk/2000/06/14/quoting.html" rel="noreferrer" target="_blank">http://web.archive.org/web/20090627155454/www.greenend.org.uk/rjk/2000/06/14/quoting.html</a><br>
_______________________________________________<br>
CentralOH mailing list<br>
<a href="mailto:CentralOH@python.org">CentralOH@python.org</a><br>
<a href="https://mail.python.org/mailman/listinfo/centraloh" rel="noreferrer" target="_blank">https://mail.python.org/mailman/listinfo/centraloh</a><br>
</blockquote></div>