analyzing excel using pandas
<p>I wanted to analyze excel files and find out the data range ( min value, max value, min len, max len, blanks etc I want to create a new analysis file which would spit out these insights. I'm looking into the panda library to do this. </p>

<pre><code>df = pd.read_excel(open('file.xlsx','rb'), sheetname='TestData')
</code></pre>

<p>How should I be proceeding ?</p>

<p>Use numpy to get the minimum/maximum etc. The functions require numpy arrays though, so either slice each column of a dataframe, or cast the dataframe as a matrix</p>

<p><a href="https://docs.scipy.org/doc/numpy/reference/generated/numpy.argmax.html" rel="nofollow">https://docs.scipy.org/doc/numpy/reference/generated/numpy.argmax.html</a></p>

python excel csv pandas