Hello, Please help with below. Thank you kindly :)
Below is the code from the example file:
import pandas as pd
#Read data stored in 'balance,txt into a DataFrame
df = pd.read_csv('balance.txt', delim_whitespace=True)
#Notice how we can use the mean() function to find average values.
print("The avereage income of a female is ", df[df.Gender == "Female"].loc[:,"Income"].mean())
print("The avereage income of a male is ",df[df.Gender == "Male"].loc[:,"Income"].mean())
# Notice how we use the groupby() function below.
# Find out more about the groupby function here: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.groupby.html#pandas.DataFrame.groupby
print(df.groupby(['Gender']).mean())
print("The avereage age of people in our dataset is ",df.loc[:, "Age"].mean())
#Besides finding average values we can also find max and min values.
# mean(), min() and max() are all methods for computing descriptive statistics.
# Find more of these types of methods here: http://pandas.pydata.org/pandas-docs/stable/getting_started/basics.html#descriptive-statistics
print("The youngest person in our dataset is ",df.loc[:, "Age"].min())
print("The oldest person in our dataset is ",df.loc[:, "Age"].max())
*** Below is the data from 'balance.txt' ***
pen and run the example file for this task in VS Code before attempting this task. ollow these steps: - Create a new Python file in this folder called Report.py. - Create a DataFrame that contains the data in balance.txt. - Write the code needed to produce a report that provides the following information: Compare the average income based on ethnicity. On average, do married or single people have a higher balance? What is the highest income in our dataset? What is the lowest income in our dataset? How many cards do we have recorded in our dataset? (Hint: use sum()) 1719.5141683970426527.33617945943612"Female""No""Yes""Caucasian"12.702778026344934.77220211673579"Male""No""No""Asian"11.56062220285436.93442702991639"Female""No""Yes""Caucasian"18.821739271852476.348469734446118"Male""No""No""Asian"9.6118885688881114.887474533935812"Male""No""Yes""AfricanAmerican"26.6347349234348121.834106737503416"Male""No""No""AfricanAmerican"11.894484957473230.132216820635217"Male""No""No""Caucasian"10.818283423221424.05269722143218"Male""No""Yes""Caucasian"9.2359122641605222.379396529223414"Female""No""Yes""Asian"11.086437512203628.316439131622910"Female""No""No""Caucasian"13.430311677426158.026749956056711"Female""No""No""Caucasian"10.279031435245610.635358429456916"Male""No""Yes""Asian"13.930641164479246.102518038238112"Male""No""Yes""AfricanAmerican"14.528897862218958.92964204592669"Female""No""Yes""AfricanAmerican"17.539143e48466780.861409033532915"Female""No""Yes""Asian"27.9764210695121158.8891158980516217"Female""No""Yes""Caucasian"11.794787531772430.42444231613014"Female""No""No""AfricanAmerican"11.117512550750636.472380630925213"Male""No""No""AfricanAmerican"11.410425885426423.365217916727515"Male""No""No""Asian"18.439668e78115483.869766755428311"Male""No""No""AfricanAmerican"15.321067784799158.351441132628516"Female""No""Yes""Caucasian"13.97e94162986555.18753523854617"Female""No""Yes""Caucasian"27.8743853510936124.29956070135217"Female""Yes""No""Asian"9.4382470170736628.508393328745614"Male""No""Yes""Asian"28.6389769769465130.2091008873073919"Female""No""Yes""Caucasian"11.349563125916230.406212018127914"Male""No""Yes""AfricanAmerican"9.4159514028164923.883538439827316"Female""No""Yes""AfricanAmerican"19.87649e81137e893.039739851716712"Male""No""Yes""AfricanAmerican"16.122559173712150.699397730428417"Female""No""No""AfricanAmerican"10.204464252974527.349200016945116"Female""No""Yes""AfricanAmerican"6.6873421839169610.40341593103437"Male""No""Yes""Asian"8.0537263289081523.949534338324018"Male""No""Yes""AfricanAmerican"20.0158422e5367673.914733352966715"Female""No""Yes""Caucasian"10.726e57826185221.038144814525813"Female""No""Yes""Caucasian"19.343517935884468.206678449954016"Female""Yes""No""AfricanAmerican"14.659235e31371657.33753103922457"Female""No""No""Caucasian"3.7494029757319210.793387832182913"Male""No""No""Caucasian"12.156283117220823.45245018027813"Male""No""No""Caucasian"8.0582441818321510.842439135853710"Female""Yes""Yes""Caucasian"14.473747115493951.345432732034615"Male""No""No""AfricanAmerican"28.1428497764105151.947915664229111"Female""No""Yes""AfricanAmerican"10.424471807494924.543320624326212"Female""No""Yes""Caucasian"11.446496868164529.567530939732515"Male""No""No""Caucasian"11.165500634737239.145435132326613"Male""No""Yes""Caucasian"8.1584629681439639.422524538324419"Male""No""No""AfricanAmerican"11.734748755904134.909528941026216"Female""No""Yes""Caucasian"13.234384521762141.025422933737919"Female""No""Yes""Caucasian"9.9696080569730715.476276221536018"Male""No""No""Asian"11.539525770439912.456539539236514"Male""No""Yes""Caucasian"7.1365283340413210.627164714927110"Female""Yes""Yes""Asian"11.738968253691338.95452223704613"Female""No""No""Caucasian"13.019268161646444.847576543735313"Female""Yes""No""Asian"23.927929934948198.515876063357811"Female""No""No""AfricanAmerican"12.508080683620933.43762074514449"Male""Yes""No""Caucasian"8.2092163047200727.51246133445217"Male""No""Yes""Asian"25.2628360009181121.7097818584506"Male""No""Yes""Caucasian"6.0479369876112915.079567341142815"Female""No""Yes""Asian" 22817.512669091591359.879690652767815"Female""No""No""Caucasian"16.821404322818466.989561443034714"Female""No""Yes""Caucasian"16.215013795122669.165466834123411"Female""No""No""AfricanAmerican"18.035219194396769.94375555473769"Male""No""Yes""Asian"12.525586737584533.2145137387359"Male""No""No""AfricanAmerican"8.7265325785822225.124477637842912"Male""No""Yes""Caucasian"9.0802241375411115.741478836013914"Male""No""Yes""Asian"8.5619068625038811.603227818737111"Male""No""Yes""Caucasian"18.058500003791569.656824457934114"Male""No""Yes""AfricanAmerican"7.503812923684110.503292323232518"Female""No""Yes""AfricanAmerican"12.605104963095942.529498636923711"Male""No""Yes""Asian"16.267460241505160.579514938853815"Male""No""Yes""Asian"11.079747746515426.532291023665819"Female""No""Yes""Caucasian"8.9787182880517927.952355726313513"Female""No""Yes""Asian"11.06095775332529.705335126257114"Female""No""Yes""Asian"4.9465442516150115.60290610323611"Male""No""Yes""AfricanAmerican"7.4915331935585720.918123312834718"Female""Yes""Yes""Asian"13.928399453013558.165661746015612"Female""No""Yes""Caucasian"10.51025990397e622.561178714746615"Female""No""No""Caucasian"11.993198197294734.509200118958018"Female""No""Yes""AfricanAmerican"9.6068639944858519.588321126545914"Female""No""No""Asian"13.774597965935236.36422201883519"Male""No""No""Caucasian"10.00524201958215.7179059313816"Male""Yes""Yes""Caucasian"9.922902870265522.574155113434313"Female""Yes""Yes""Caucasian"8.5734482105325510.363243019124718"Female""No""Yes""Asian"11.834543663249428.474320226756612"Male""No""Yes""Caucasian"19.575548749723372.94586036213648"Female""No""No""Caucasian"19.949835089522485.425518240266112"Male""No""Yes""AfricanAmerican"13.997826202937536.50863864694796"Female""No""Yes""Caucasian"14.658412846596258.06342213043508"Male""No""No""AfricanAmerican"11.015675695429125.936177413527114"Female""No""No""Asian"7.6449872359250715.629249318616014"Male""No""Yes""Asian"12.067218767349641.4256121523614"Male""No""Yes""Caucasian"14.669464424684433.65761964506559"Female""No""No""Caucasian"18.610377058026767.937518438346312"Male""No""Yes""Asian"38.7851230052754180.37993106653678"Female""Yes""Yes""Asian"7.6539785624532110.588404929616613"Female""No""Yes""Caucasian"9.0724980603156329.725353627025215"Female""No""No""AfricanAmerican"9.0233133128503427.999510738015510"Male""No""Yes""Caucasian"12.140614033333140.885501337934613"Female""No""Yes""AfricanAmerican"21.586866384834688.83495236048616"Female""No""Yes""Caucasian"11.59351824475829.638583343332915"Female""No""Yes""Asian"10.219995883390125.988134914248212"Male""No""No""Caucasian"11.521169014884439.055556541044818"Female""No""Yes""Caucasian"8.9081872771193315.866308521713913"Male""No""No""Caucasian"13.751052714554344.978486634713010"Female""No""No""Caucasian"9.8851554498855830.413369029922515"Female""Yes""No""Asian"10.021701649474616.751476635364814"Male""Yes""No""Asian"10.8890e8262189630.5558694395819"Female""No""No""AfricanAmerican"30.2120795527654163.329873263635014"Male""No""Yes""Caucasian"9.9613344489027523.106347625725015"Female""No""No""Caucasian"12.28948173930741.532500035325012"Male""No""Yes""Caucasian"25.9416471981062128.64698251827811"Female""No""Yes""Caucasian"15.499486183182554.31930632483598"Female""Yes""No""Caucasian"13.9eg46631176253.40153193773512"Female""No""No""AfricanAmerican"11.447728118928236.142185218333313"Female""No""No""AfricanAmerican"15.855333291166963.534810058125017"Female""No""Yes""Caucasian" 15.855333291166963.534810058125017"Female""No""Yes""Caucasian"16.737655157453349.927639648537517"Female""No""Yes""Caucasian"8.2984818785959614.71120471672676"Male""No""Yes""Caucasian"10.758618434364118.967162615624111"Female""No""Yes""Asian"10.305965461882618.036155214224815"Female""No""No""Caucasian"15.870994700992160.44930982724698"Male""No""Yes""Caucasian"8.8689590999547116.711527438734216"Female""No""Yes""Asian"6.5422558098538510.85239072962309"Male""No""No""Caucasian"10.776692231615226.37323526857811"Male""No""Yes""Asian"10.633792001027524.088366528745613"Female""No""Yes""Caucasian"12.862578426235751.532509638023115"Male""No""Yes""Caucasian"28.197e849585771140.672112008177469"Male""No""Yes""AfricanAmerican"11.406729980559342.915253220544213"Male""No""Yes""Asian"12.386509948453127.272138914956710"Female""No""Yes""Caucasian"16.627425125900165.896514037914917"Female""No""Yes""Caucasian"14.924e7811198755.054438132137417"Male""No""Yes""Asian"9.143629500238320.791267220417618"Female""No""No""AfricanAmerican"9.0543556690161824.919505137237611"Female""No""Yes""AfricanAmerican"10.168699655569621.786463235515017"Male""No""Yes""Caucasian"10.309111651053531.33535262893387"Female""No""No""Caucasian"13.630270183321659.855496436514613"Female""No""Yes""Caucasian"15.022034525294544.061497035217911"Male""No""Yes""AfricanAmerican"18.60e3e2e16683782.706750653626413"Female""No""Yes""Asian"12.742936894386224.46192416525014"Female""No""Yes""Asian"14.53397392679645.1237622873808"Male""No""Yes""Caucasian"16.801395230204575.406387429834114"Female""No""Yes""Asian"7.1604116787151314.95646403322336"Male""No""No""Asian"14.812832609646475.257701049433418"Female""No""Yes""Caucasian"11.073990168689533.694489136915216"Male""Yes""No""AfricanAmerican"10.292599710302823.375542939635715"Female""No""Yes""Caucasian"11.317446772097127.825522738666311"Male""No""Yes""Caucasian"21.542957791586992.386768553427518"Female""No""Yes""Asian"24.0e88924887599115.52927265626914"Male""No""No""AfricanAmerican"7.4431658411011614.479390729634316"Male""No""Yes""Caucasian"15.753006808770552.179730652225714"Male""No""No""Asian"17.767911364546468.462471234027116"Male""No""Yes""Caucasian"10.783185698577418.951148512938213"Female""No""No""Caucasian"10.062003494333527.59258622955416"Male""No""Yes""AfricanAmerican"7.9317247650213116.279116012637813"Male""Yes""Yes""AfricanAmerican"9.5282094886244625.078309623622715"Female""No""Yes""Caucasian"11.764441584318227.229348428265111"Male""No""No""Caucasian"33.7455798468381182.7281391398249817"Male""No""Yes""Caucasian"11.269897402777531.029286322326617"Male""Yes""Yes""Asian"10.18548340787717.765507236416612"Female""No""Yes""Caucasian"24.2812701158326125.481023072138216"Male""No""Yes""Caucasian"16.341416852951349.166666250836814"Female""No""No""Asian"12.550640818736441.192367329735416"Female""No""Yes""Caucasian"20.260447651175694.193757652724416"Female""No""Yes""Caucasian"10.17931187671620.405454332927217"Male""Yes""No""Asian"8.1878897380509612.581397629124816"Male""No""Yes""Caucasian"15.224969379812262.328522837738315"Male""No""No""Caucasian"7.9075776301659221.011340226126817"Male""No""Yes""AfricanAmerican"10.429717935734324.23475635126415"Female""No""Yes""Caucasian"9.9077578166546924.31434092702237"Female""No""Yes""Caucasian"12.092162687393232.856588443846813"Male""No""No""Caucasian"8.1822078479491912.41485511933212"Male""No""Yes""AfricanAmerican"15.480793011015741.365530337714514"Male""No""No""Caucasian
