how to analyse data which is in excel . For example - no of people apply for loan ..data includes 13 col like salary, documents.

Question

I know base ML with python

Answer 1

Abhi Vashisth, .any() method on the column checks if there are True values in it. .sum() method finds sum of all elements in the column. .mean() - mean of the column. Boolean indexing filters raws that don't correspond to some condition.

Basic examples can be found in the official tutorial:

http://pandas.pydata.org/pandas-docs/stable/10min.html

Answer 2

Abhi Vashisth, if I understand your task correctly, you can create new table column with values depending on other columns. And then find some value in this column. New columns can be created with arithmetic operations on other columns.

For example if we have column with deposit amounts and column with deposit percentages the maximum payment can be found like this:

df["pay"] = df["amount"] * (df["percentage"] / 100)

print( df["pay"].max() )

Not sure I can give more detailed advice, check out pandas documentation.

Answer 3

Use pandas library for Python. It has built-in tools for reading tables (including xls) and advanced data analysis.

Answer 4

yeah i know pandas can read file but name few methods which will give me some idea to analyse data

Answer 5

thanks wiad ! but at the end I want to analyse who all can get better results of loans request . It can be done by any method or I have to do manually after using ( a.sum, a.any)?

Answer 6

thanks wiad!