0

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

I know base ML with python

9th Aug 2018, 10:51 AM
Abhi Vashisth
Abhi Vashisth - avatar
6 ответов
0
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
9th Aug 2018, 11:54 AM
wiad
+ 1
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.
9th Aug 2018, 1:02 PM
wiad
0
Use pandas library for Python. It has built-in tools for reading tables (including xls) and advanced data analysis.
9th Aug 2018, 11:11 AM
wiad
0
yeah i know pandas can read file but name few methods which will give me some idea to analyse data
9th Aug 2018, 11:14 AM
Abhi Vashisth
Abhi Vashisth - avatar
0
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)?
9th Aug 2018, 12:09 PM
Abhi Vashisth
Abhi Vashisth - avatar
0
thanks wiad!
9th Aug 2018, 3:37 PM
Abhi Vashisth
Abhi Vashisth - avatar