Statement of Completion#f90e5f26
Khush Patel has successfully completed this project.
Intro to Pandas for Data Analysis
easy
DataFrames practice: working with English Words
Resolution
Activities
In [1]:
import pandas as pd
In [2]:
df = pd.read_csv('words.csv', index_col='Word')
In [3]:
df.head()
Out[3]:
| Char Count | Value | |
|---|---|---|
| Word | ||
| aa | 2 | 2 |
| aah | 3 | 10 |
| aahed | 5 | 19 |
| aahing | 6 | 40 |
| aahs | 4 | 29 |
Activities¶
How many elements does this dataframe have?¶
In [4]:
len(df)
Out[4]:
172821
What is the value of the word microspectrophotometries?¶
In [14]:
df[df.index == 'microspectrophotometries']['Value']
Out[14]:
Word microspectrophotometries 317 Name: Value, dtype: int64
What is the highest possible value of a word?¶
In [46]:
max(df['Value'])
Out[46]:
319
Which of the following words have a Char Count of 15?¶
In [26]:
for i in df.index:
if len(i) == 15:
print(i)
absorbabilities abstractionisms abstractionists acanthocephalan acceptabilities acceptingnesses accessibilities acclimatization accommodatingly accommodational accomplishments accountableness accountantships acculturational acetophenetidin achondroplasias achondroplastic acknowledgement acknowledgments acquisitiveness acrimoniousness adenocarcinomas adenohypophyses adenohypophysis adjustabilities administrations admirablenesses admissibilities adrenalectomies adventurousness adversarinesses advisablenesses aerodynamically aerodynamicists aerosolizations affectabilities affordabilities agglutinability aggrandizements aggregatenesses agranulocytoses agranulocytosis agreeablenesses agribusinessman agribusinessmen agriculturalist airworthinesses algorithmically alkalinizations allegoricalness allegorizations allelomorphisms allergenicities allotetraploids allotetraploidy alphabetization alternativeness aluminosilicate ambassadorships ambidexterities ambiguousnesses ambisexualities ambitiousnesses aminopeptidases ammonifications amorphousnesses amphidiploidies amphitheatrical anacoluthically anagrammatizing analogousnesses analyzabilities ancylostomiases ancylostomiasis anfractuosities anisotropically ankylostomiases ankylostomiasis anomalousnesses anonymousnesses antepenultimate anthropocentric anthropological anthropologists anthropometries anthropomorphic anthropopathism anthropophagies anthropophagous anthroposophies antiabortionist antialcoholisms antiallergenics antiaphrodisiac antiarrhythmics anticapitalisms anticapitalists anticarcinogens anticholesterol anticholinergic anticlericalism anticlericalist anticlimactical anticolonialism anticolonialist anticompetitive anticonvulsants anticonvulsives anticorruptions antidepressants antidepressions antiderivatives antidevelopment antieducational antiegalitarian antifashionable antifederalists antiferromagnet antifilibusters antiforeclosure antihistaminics antiliberalisms antilibertarian antilogarithmic antimanagements antimaterialism antimaterialist antimetabolites antimilitarisms antimilitarists antimonarchical antimonarchists antimonopolists antinationalist antiobscenities antiperspirants antipornography antiprogressive antiquarianisms antiradicalisms antirationalism antirationalist antirationality antiromanticism antisegregation antisentimental antiseparatists antisexualities antishoplifting antispeculation antispeculative antisubversions antisubversives antisyphilitics antitheoretical antitraditional antituberculous antivivisection apocalyptically apocalypticisms apolipoproteins appealabilities applicabilities apprenticeships approachability appropriateness arbitrarinesses archaebacterium archaeopteryxes archeologically archiepiscopate architecturally argumentatively ariboflavinoses ariboflavinosis aromatherapists arrondissements arteriographies artificialities assertivenesses assiduousnesses assignabilities assimilationism assimilationist associationisms associationists associativities astrobiologists astronautically astrophotograph astrophysically astrophysicists atheroscleroses atherosclerosis atherosclerotic atmospherically atrabiliousness atrociousnesses attainabilities attentivenesses audaciousnesses authentications authoritatively autobiographers autobiographies autochthonously autocorrelation autographically automatizations autoradiographs autoradiography autosuggestions autotetraploids autotetraploidy autotransformer autotransfusion autotrophically availablenesses axiomatisations axiomatizations azidothymidines backscatterings bacteriological bacteriologists bacteriophagies barbarousnesses barefacednesses basidiomycetous bastardizations bathymetrically beauteousnesses beautifications beautifulnesses believabilities belongingnesses benightednesses benzanthracenes benzodiazepines bibliographical bibliotherapies bidialectalisms bidirectionally bioavailability biodegradations bioengineerings biogeochemicals biogeochemistry biogeographical bioluminescence biomathematical biomechanically biostatistician biostratigraphy biosystematists biotechnologies biotechnologist bipartisanships bipolarizations bittersweetness bituminizations blamelessnesses blameworthiness blasphemousness blaxploitations bloodguiltiness bloodlessnesses bougainvillaeas bouleversements boundlessnesses bounteousnesses bountifulnesses bourgeoisifying boustrophedonic bowdlerizations brachycephalies brainlessnesses braunschweigers breathabilities bremsstrahlungs bronchodilators bronchoscopists brotherlinesses bumptiousnesses bureaucratising bureaucratizing businesspersons cannibalization capaciousnesses capitalizations carcinogenicity carcinosarcomas cardiopulmonary carnivorousness carpetbaggeries cataclysmically categorizations catheterization ceaselessnesses centralizations centrifugations centrosymmetric cephalothoraces cephalothoraxes cerebrovascular ceremoniousness chancellorships changeabilities changefulnesses channelizations characteristics cheerlessnesses chemoautotrophy chemoreceptions chemotactically chemotaxonomies chemotaxonomist chemotherapists childlessnesses childlikenesses chincherinchees chloramphenicol chlorothiazides chlorpromazines chlorpropamides cholangiography cholecalciferol cholecystectomy cholecystitides cholecystitises cholecystokinin cholestyramines cholinergically cholinesterases chondrocraniums chordamesoderms chorioallantoic chorioallantois choriocarcinoma chromatographed chromatographer chromatographic chronobiologies chronobiologist chronologically chronotherapies churrigueresque cinematographer cinematographic circularization circumambiently circumambulated circumambulates circumferential circumlocutions circumnavigated circumnavigates circumnavigator circumscription circumspections circumstantiate circumvallating circumvallation circumvolutions citriculturists civilianization clamorousnesses clandestineness clandestinities classifications classlessnesses claustrophobias clearheadedness cleistogamously cloudlessnesses coagulabilities codetermination codifiabilities coeducationally coenzymatically coinvestigators coldheartedness collaboratively collateralities collateralizing collectednesses collenchymatous colloquialities colonizationist colorfastnesses colorlessnesses combativenesses combinatorially comfortableness commemoratively commensurations commercialising commercialistic commercialities commercializing commiseratingly commissionaires commodification commonplaceness communicability communicational communicatively communistically commutativities comparabilities comparativeness compassionately compassionating compatibilities compendiousness competitiveness complementaries complementarily complementarity complementation complementizers complicatedness complimentarily compositionally comprehensively compressibility comptrollership computabilities computationally computerization computerphobias comradelinesses conceitednesses conceivableness concelebrations concentricities conceptualising conceptualistic conceptualities conceptualizers conceptualizing concertednesses concertmeisters concessionaires concretizations condescendences condescendingly conducivenesses confectionaries confectioneries confessionalism confessionalist confidentiality confidingnesses configurational confirmednesses confraternities confrontational conglomerateurs conglomerations conglutinations congratulations congressionally congresspersons congruousnesses conjugatenesses conjugationally conjunctionally connaturalities connectednesses connoisseurship consanguinities conscientiously consciousnesses consecutiveness consentaneously consequentially conservationist conservatorship considerateness conspicuousness constitutionals constructionist constructivisms constructivists consultantships containerboards contemplatively contemporaneity contemporaneous contemptibility contentednesses contentiousness contextualizing contortionistic contractibility contractilities contradictories contradictorily contraindicated contraindicates contrapositions contrapositives controllability controllerships controversially conventionalism conventionalist conventionality conventionalize convertibleness conveyorization cooperationists cooperativeness corporealnesses correspondences correspondingly corrigibilities corrosivenesses corticosteroids corticosterones corticotrophins corynebacterial corynebacterium cosmopolitanism cotransductions coulometrically councillorships counterargument counterassaults counterattacked counterattacker counterbalanced counterbalances counterblockade countercampaign counterchanging countercharging counterchecking counterclaiming countercultural countercultures countercurrents countercyclical counterevidence counterexamples counterguerilla counterinstance counterirritant countermarching countermeasures countermelodies countermovement counterordering counterpetition counterpicketed counterplotting counterpointing counterpressure counterprojects counterproposal counterprotests counterpunchers counterpunching counterquestion counterrallying counterreaction counterreformer counterresponse countershadings counterstaining counterstepping counterstrategy countertendency counterviolence counterweighted courteousnesses crashworthiness creditabilities credulousnesses crestfallenness criminalization crosslinguistic crossopterygian crotchetinesses cryoprotectants cryptanalytical cryptorchidisms cryptozoologies cryptozoologist crystallinities crystallization crystallography cultivabilities customarinesses cyanocobalamine cyanocobalamins cyanoethylating cyanoethylation cyclohexylamine cyproheptadines cytochemistries cytogenetically cytogeneticists cytomegalovirus cytophotometric cytoplasmically daguerreotypies daguerreotyping daguerreotypist damageabilities dangerousnesses dastardlinesses dauntlessnesses deacidification deathlessnesses decaffeinations decalcification decarboxylating decarboxylation decarburization decasualization deceitfulnesses deceptivenesses decertification dechlorinations deciduousnesses decimalizations decolonizations decolorizations decommissioning decompensations decomposability deconcentrating deconcentration deconsecrations deconstructions decontaminating decontamination decontaminators decriminalizing dedifferentiate deductibilities defeasibilities defectivenesses defeminizations defenestrations defenselessness defensibilities defensivenesses defibrillations deglamorization dehumanizations dehydrogenating dehydrogenation deindustrialize delectabilities delegitimations deleteriousness deliciousnesses delightednesses deliriousnesses delocalizations demagnetization demandingnesses dematerializing demisemiquavers demobilizations democratization demographically demonetizations demonstrability demonstrational demonstratively demoralizations demystification demythologizers demythologizing denationalizing denazifications denitrification departmentalize dependabilities depersonalizing dephosphorylate depigmentations depolarizations derivatizations dermatoglyphics desacralization desalinizations descriptiveness desensitization desertification desexualization desirablenesses desperatenesses despiritualized despiritualizes dessertspoonful destabilization destitutenesses destructibility destructionists destructiveness destructivities desulfurization desultorinesses detachabilities detectabilities determinateness deterrabilities detoxifications detribalization deuteranomalies deuteranomalous developmentally devitrification dexterousnesses diagonalization dialectological dialectologists diastereoisomer diastrophically dichlorobenzene dichloroethanes dichotomization dichotomousness dictatorialness differentiating differentiation differentnesses diffractometers diffractometric diffusivenesses digestibilities digitalizations dimenhydrinates dinitrobenzenes dinoflagellates diphenhydramine disaccharidases disadvantageous disaffiliations disaggregations disambiguations disappointingly disappointments disapprobations disarrangements disarticulating disarticulation disassociations disciplinarians discombobulated discombobulates disconcertingly disconcertments disconformities disconsolations discontentments discontinuances discontinuation discontinuities discontinuously discountenanced discountenances discouragements discriminations disembarkations disembarrassing disembowelments disenchantingly disenchantments disenfranchised disenfranchises disentanglement disequilibrated disequilibrates disequilibriums disestablishing disfurnishments disgracefulness disgruntlements dishearteningly disheartenments disillusionment disinclinations disinfestations disinflationary disinformations disinheritances disintegrations disinterestedly disintoxicating disintoxication disorganization disorientations disparatenesses dispassionately disposabilities disproportional disproportioned disreputability disrespectfully dissatisfaction dissatisfactory dissimilarities dissolutenesses distastefulness distemperatures distinctiveness distinguishable distinguishably distractibility distressfulness distributorship distrustfulness dithiocarbamate dithyrambically diversification divertissements documentational dolichocephalic dolomitizations domineeringness dorsiventrality dorsoventrality doubtlessnesses downheartedness downrightnesses dramaturgically dreamlessnesses dyslogistically easygoingnesses ecclesiasticism ecclesiological ecclesiologists echinodermatous echocardiograms eclaircissement ecocatastrophes econometrically econometricians ecophysiologies educationalists effectivenesses effectualnesses efficaciousness effortfulnesses egalitarianisms eggheadednesses egocentricities egregiousnesses elaboratenesses electrification electroacoustic electroanalyses electroanalysis electrochemical electrodeposits electrodialyses electrodialysis electrodialytic electrodynamics electrofishings electrokinetics electromagnetic electromyograms electromyograph electronegative electrophoresed electrophoreses electrophoresis electrophoretic electropositive electrosurgical electrowinnings emancipationist embryologically emotionlessness employabilities emulsifications enantiomorphism enantiomorphous encephalitogens encephalographs encephalography encephalopathic endocrinologies endocrinologist endometriosises endonucleolytic endoparasitisms enfranchisement enjoyablenesses enterobacterial enterobacterium enterocolitises enterogastrones entomologically entrepreneurial enumerabilities envenomizations environmentally epeirogenically epichlorohydrin epidemiological epidemiologists epigrammatizers epigrammatizing epiphenomenally epistemological epistemologists epithelializing epitheliomatous epithelizations epizootiologies equalitarianism equitablenesses equivocalnesses erroneousnesses erythropoietins essentialnesses esterifications estimablenesses etherealization ethnocentricity ethnohistorians ethnohistorical ethnomusicology eudiometrically euphemistically eutrophications evangelizations everlastingness evocativenesses exaggeratedness exceptionalisms exceptionalness excessivenesses exchangeability excitablenesses excludabilities exclusivenesses excommunicating excommunication excommunicative excommunicators excrementitious excursivenesses excusablenesses execrablenesses exemplarinesses exemplification exhaustlessness exhibitionistic existentialisms existentialists exoerythrocytic exothermicities expandabilities expansibilities expansivenesses expeditiousness expendabilities expensivenesses experimentalism experimentalist experimentation explosivenesses exponentiations exportabilities expressionistic exquisitenesses exsanguinations extemporisation extemporization extendabilities extensibilities extensivenesses exteriorization externalisation externalization extinguishments extracellularly extracurricular extrajudicially extralinguistic extraordinarily extrudabilities facetiousnesses faithlessnesses familiarization fanaticalnesses fantasticalness fantastications fashionableness fatheadednesses faultlessnesses favorablenesses featherbeddings featherstitched featherstitches federalizations feloniousnesses fencelessnesses ferociousnesses ferrimagnetisms ferromagnetisms ferromanganeses fetishistically fibrinopeptides fictionizations filterabilities fingerprintings fissiparousness flibbertigibbet flirtatiousness floriculturists floriferousness foolhardinesses foreordinations foresightedness forgetfulnesses forgivingnesses formidabilities formularization fortunatenesses fortunetellings fractionalizing fractiousnesses fragmentariness fraternizations frenchification frightfulnesses frivolousnesses fructifications fruitlessnesses functionalistic functionalities fundamentalisms fundamentalists futilitarianism garrulousnesses gastroenteritis gastronomically gelatinizations generalisations generalizations gentlemanliness gentrifications geochronologies geochronologist geohydrologists geomagnetically geometrizations geomorphologies geomorphologist geostrophically geotectonically germinabilities gewurztraminers glamorousnesses glucocorticoids gluconeogeneses gluconeogenesis glutaraldehydes glyceraldehydes gnotobiotically governmentalism governmentalist governmentalize gracelessnesses grammaticalness grandiloquences grandiloquently grandiosenesses grandparenthood graphitizations gravimetrically gravitationally greensicknesses grotesquenesses guilelessnesses guiltlessnesses gynandromorphic gyrofrequencies gyrostabilizers habitablenesses halfheartedness hallucinogenics haphazardnesses hardheartedness harpsichordists hazardousnesses headmasterships healthfulnesses heartbreakingly heartlessnesses heartsicknesses heliometrically helminthologies hemagglutinated hemagglutinates hematoporphyrin hemochromatoses hemochromatosis hemodynamically hemoflagellates hemoglobinurias hendecasyllabic hendecasyllable hermaphroditism hermeneutically heterochromatic heterochromatin heterogeneities heterogeneously heteromorphisms heterosexuality heterothallisms hexachlorethane hexachlorophene hexosaminidases hexylresorcinol hilariousnesses histochemically histopathologic histophysiology historiographer historiographic holographically holometabolisms homeopathically homogeneousness homogenisations homogenizations homosexualities homotransplants honorablenesses horizontalities horticulturally horticulturists hospitalization hotheadednesses houselessnesses housewifeliness humanitarianism humidifications humorlessnesses hydrobiological hydrobiologists hydrocephaluses hydrocortisones hydrodynamicist hydromechanical hydrometallurgy hydrostatically hydroxyapatites hydroxylapatite hydroxyprolines hyperactivities hyperaesthesias hyperaggressive hypercatabolism hypercatalectic hypercoagulable hypercorrection hypercritically hypercriticisms hyperexcitement hyperexcretions hyperextensions hyperfastidious hyperfunctional hyperimmunizing hyperinflations hyperinsulinism hyperinvolution hyperlipidemias hypermetabolism hypermobilities hypermodernists hypermutability hyperparasitism hyperpolarizing hyperproduction hyperreactivity hyperresponsive hypersalinities hypersalivation hypersecretions hypersensitized hypersensitizes hypersomnolence hyperstimulated hyperstimulates hyperthyroidism hypertonicities hypervelocities hyperventilated hyperventilates hypervigilances hypnotherapists hypnotizability hypochondriacal hypochondriases hypochondriasis hypomagnesemias hypopituitarism hyposensitizing hypostatization hypothyroidisms hysterectomized ichthyosaurians identicalnesses identifications ideographically idiomaticnesses ignominiousness illegalizations illiberalnesses illimitableness illogicalnesses illustriousness imaginarinesses imaginativeness imitativenesses immaterialities immaterializing immediatenesses immiscibilities immobilizations immortalization immovablenesses immunoassayable immunoblottings immunochemistry immunocompetent immunodeficient immunodiagnoses immunodiagnosis immunodiffusion immunoglobulins immunologically immunomodulator immunopathology immunotherapies immutablenesses impalpabilities impassabilities impassibilities impassivenesses impeccabilities impecuniosities impecuniousness impenetrability imperfectnesses imperiousnesses imperishability impersonalities impersonalizing impetuousnesses implacabilities implementations implicativeness imponderability importunateness impossibilities impoverishments imprecisenesses impregnableness impressionistic improbabilities improvabilities improvisational improvisatorial impulsivenesses inaccessibility inadmissibility inalterableness inanimatenesses inapplicability inappropriately inattentiveness incalculability incapablenesses incapacitations inclusivenesses incommensurable incommensurably incommunicative incomparability incompatibility incomprehension incongruousness inconsequential inconsiderately inconsideration inconsistencies inconspicuously inconveniencies inconveniencing incoordinations incorrectnesses incorrigibility incorruptnesses incredibilities incrementalisms incrementalists incuriousnesses indefeasibility indefectibility indefensibility indefinableness indemnification indeterminacies indeterminately indetermination indeterministic indifferentisms indifferentists indigenizations indigestibility indisciplinable indissolubility individualising individualistic individualities individualizing indoctrinations indomitableness indubitableness industrialising industrializing industriousness ineducabilities ineffablenesses ineffaceability ineffectiveness ineffectualness inefficaciously ineligibilities ineradicability inevitabilities inexcusableness inexorabilities inexpensiveness inexplicability inextricability infallibilities infantilization infeasibilities infinitesimally inflammableness inflexibilities informationally informativeness infrastructures infundibuliform infusiblenesses ingeniousnesses ingenuousnesses inheritableness inhomogeneities inhospitalities initializations injudiciousness injuriousnesses innocuousnesses inoffensiveness inoperativeness inopportuneness inquisitiveness inquisitorially insatiabilities insatiatenesses inscrutableness insensibilities insensitiveness insensitivities inseparableness insidiousnesses insignificances insignificantly insociabilities insolublenesses inspirationally instantaneities instantaneously institutionally instructiveness instructorships instrumentalism instrumentalist instrumentality instrumentation insubordinately insubordination insufficiencies insurrectionary insurrectionist intangibilities integrabilities integrationists intellectualism intellectualist intellectuality intellectualize intelligentsias intelligibility intemperateness intensification intensivenesses interanimations interbehavioral interchangeable interchangeably intercollegiate intercommunions intercomparison interconnecting interconnection interconversion interconverting intercorrelated intercorrelates interculturally interdependence interdependency interdiffusions interdigitating interdigitation interdivisional interelectrodes interelectronic interestingness interferometers interferometric interfraternity intergeneration intergradations interindividual interinfluenced interinfluences interiorization interlacustrine interlineations intermediations intermittencies intermodulation internalization internationally internucleotide interoperatives interparoxysmal interpellations interpenetrated interpenetrates interperceptual interpermeating interpersonally interphalangeal interpopulation interpretations interprovincial interrogational interrogatively interrogatories interscholastic interstratified interstratifies intersubjective intertwinements interuniversity intervalometers interventionism interventionist intervisibility intervisitation intolerableness intracellularly intracerebrally intramuscularly intransigeances intransigeantly intraperitoneal intrapopulation intrapreneurial intravascularly intricatenesses introspectional introspectively intrusivenesses intuitivenesses intussuscepting intussusception intussusceptive invariabilities invectivenesses inventivenesses investigational invidiousnesses invincibilities inviolabilities inviolatenesses invisiblenesses involuntariness invulnerability ionospherically irasciblenesses irrationalistic irrationalities irreconcilables irreformability irrefragability irreparableness irrepealability irresistibility irreversibility irrevocableness irritablenesses judiciousnesses jurisprudential juxtapositional kaffeeklatsches keratinizations kindergarteners kindheartedness kinesthetically kittenishnesses kremlinologists laboriousnesses labyrinthodonts lackadaisically laryngectomized latensification lateralizations latitudinarians laughablenesses lecherousnesses legislatorships legitimizations leisurelinesses lepidopterology leukaemogeneses leukaemogenesis levelheadedness lexicalisations lexicalizations lexicographical liberalizations libertarianisms lickerishnesses lightfastnesses lightsomenesses lignocelluloses lignocellulosic lignosulfonates limitlessnesses literalizations litigiousnesses liturgiologists loathsomenesses logarithmically logographically longsightedness lucrativenesses ludicrousnesses luxuriousnesses lymphadenitises lymphadenopathy lymphangiograms lymphocytosises lymphogranuloma lymphosarcomata lyophilizations lysogenizations machinabilities macroaggregated macroaggregates macrocosmically macroevolutions macrophotograph macroscopically macrostructural macrostructures magistratically magnanimousness magnetoelectric maintainability majoritarianism maladministered maladroitnesses maldistribution maliciousnesses malpractitioner manageabilities maneuverability marginalization marketabilities marriageability martensitically marvelousnesses masculinization masochistically masterfulnesses mastoidectomies materfamiliases materialization mathematization meaninglessness measurabilities mechanistically mechanochemical mechanoreceptor medulloblastoma megacorporation megagametophyte megasporophylls mellifluousness melodiousnesses melodramatising melodramatizing memorablenesses mensurabilities mercaptopurines mercenarinesses merchantability mercilessnesses mercurialnesses meritoriousness meroblastically metafictionists metalinguistics metallographers metallographies metallurgically metamathematics metamorphically metastabilities methamphetamine methoxyfluranes methylcellulose methylmercuries methylphenidate methylxanthines microanalytical microanatomical microbarographs microbiological microbiologists microcosmically microdissection microearthquake microelectrodes microelectronic microevolutions microgametocyte microinjections micromanagement micrometeorites micrometeoritic micrometeoroids micromorphology microphotograph microphotometer microphotometry microphysically microporosities microprocessors microprojection microprojectors micropublishers micropublishing micropulsations microradiograph microscopically microseismicity microsporangium microsporocytes microsporophyll microstructural microstructures microtechniques microtonalities militarizations millenarianisms millionairesses mineralizations mineralogically miniaturization misapplications misapprehending misapprehension misappropriated misappropriates misarticulating misattributions miscalculations miscegenational miscellaneously mischaracterize mischievousness miscomputations misconstruction miscorrelations misdescriptions misdistribution miserablenesses misguidednesses misinformations misinterpreting mismeasurements misorientations misrecollection misregistration misrepresenting missionizations mistranscribing mistranslations mistrustfulness misutilizations misvocalization modifiabilities momentarinesses momentousnesses mongrelizations monochromatisms monocrystalline monomolecularly mononucleosises mononucleotides monopolizations monopropellants monosaccharides monospecificity monosyllabicity monounsaturated monounsaturates monstrousnesses montmorillonite monumentalities monumentalizing morphologically morphophonemics mountaineerings mountainousness mountebankeries mouthwateringly multidiscipline multidivisional multifunctional multilateralism multilateralist multilingualism multimillennial multiplications multipolarities multiprocessing multiprocessors multiracialisms multitudinously multiwavelength murderousnesses musculoskeletal musicalizations nationalization naturalizations nearsightedness necessitousness necromantically negligibilities negotiabilities neocolonialisms neocolonialists neoconservatism neoconservative nephrectomizing nervelessnesses neuroanatomical neuroanatomists neurobiological neurobiologists neuroblastomata neurofibrillary neurohypophyses neurohypophysis neuropathically neuropathologic neurophysiology neuropsychiatry neuropsychology neuroscientific neuroscientists neurosecretions neurotoxicities neutralizations niggardlinesses nincompooperies nitrocelluloses nitroglycerines nonachievements nonadditivities nonagricultural nonantagonistic nonarchitecture nonaristocratic nonastronomical nonavailability nonbarbiturates nonbelligerency nonbelligerents nonbiographical nonbiologically noncarcinogenic noncelebrations noncertificated noncoincidences noncombustibles noncompressible noncomputerized nonconcurrences nonconfidential nonconformances nonconformities nonconservation nonconservative nonconsolidated nonconstruction nonconstructive nonconsumptions noncontemporary noncontributory noncontrollable nonconventional noncooperations noncorrelations noncreativities noncredentialed noncultivations nondepartmental nondevelopments nondisjunctions nonelectrolytes nonencapsulated nonenforcements nonengineerings nonequilibriums nonequivalences nonexperimental nonexploitation nonexploitative nonflammability nonfulfillments nongovernmental nonhierarchical nonhospitalized nonimplications nonimportations nonindependence noninflammatory noninflationary noninflectional noninformations noninsecticidal noninstrumental nonintellectual nonintercourses noninterference nonintersecting nonintervention nonintimidating nonintoxicating noninvolvements nonmathematical nonmatriculated nonmetaphorical nonmetropolitan nonobjectivisms nonobjectivists nonoccupational nonoverlappings nonparticipants nonpartisanship nonperformances nonphilosophers nonphotographic nonprescription nonprofessional nonprofessorial nonprogressives nonpsychiatrist nonquantifiable nonquantitative nonrandomnesses nonrecognitions nonrecombinants nonrelativistic nonreproducible nonreproductive nonsaponifiable nonsedimentable nonsegregations nonsensicalness nonsimultaneous nonspecifically nonstationaries nontotalitarian nontransferable nonuniformities nonuniquenesses nonuniversities nonutilitarians norepinephrines normativenesses notwithstanding novemdecillions nucleophilicity nucleosyntheses nucleosynthesis nucleosynthetic objectification objectivenesses obliviousnesses obnoxiousnesses observabilities observationally obsessivenesses obstinatenesses obstructionisms obstructionists obstructiveness obtainabilities obtrusivenesses occidentalizing oceanographical odoriferousness offensivenesses offhandednesses officiousnesses oligodendrocyte oligodendroglia oligomerization oligonucleotide oligosaccharide omnicompetences omnidirectional ontogenetically openheartedness openmouthedness operationalisms operationalists operativenesses ophthalmologies ophthalmologist ophthalmoscopes ophthalmoscopic opinionatedness opportunenesses opprobriousness optoelectronics orchestrational organochlorines organomercurial organometallics organophosphate orientationally orthodontically orthogonalities orthogonalizing orthophosphates orthopsychiatry oscillographies osmoregulations osteomyelitides osteopathically outdoorsmanship outmanipulating outspokennesses overabstracting overaccentuated overaccentuates overachievement overadjustments overadvertising overapplication overarticulated overarticulates overassessments overcapitalized overcapitalizes overcentralized overcentralizes overclassifying overcommitments overcommunicate overcompensated overcompensates overcompliances overcomplicated overcomplicates overcompressing overconfidences overconfidently overconstructed overconsumption overcontrolling overcorrections overcultivation overdecorations overdependences overdevelopment overdiscounting overdiversities overdocumenting overdramatizing overeagernesses overelaborating overelaboration overembellished overembellishes overemphasizing overencouraging overengineering overentertained overenthusiasms overestimations overevaluations overexaggerated overexaggerates overexpectation overextractions overextravagant overfamiliarity overfertilizing overgeneralized overgeneralizes overglamorizing overhomogenized overhomogenizes overidentifying overimaginative overindulgences overingenuities overintensities overinvestments overlengthening overmedications overopinionated overorchestrate overornamenting overpersuasions overpopulations overprescribing overproductions overprogramming overproportions overprotections overrefinements overregulations overrepresented oversaturations oversensitivity oversimplifying overspecialized overspecializes overspeculating overspeculation overstabilities overstimulating overstimulation oversubscribing oversweetnesses overutilization overwithholding overzealousness ovoviviparously oxidoreductases oxyphenbutazone oxytetracycline painterlinesses palatablenesses palatalizations paleobiological paleobiologists paleoecological paleoecologists paleogeographic paleomagnetisms paleomagnetists paleontological paleontologists paleozoological paleozoologists palynologically pantheistically pantisocratical pantisocratists paradoxicalness paragenetically parajournalisms paralinguistics parallelepipeds parametrization paramyxoviruses paranormalities pararosanilines parasexualities parasitizations parasitological parasitologists parasympathetic parenthetically parliamentarian parthenocarpies parthenogeneses parthenogenesis parthenogenetic participational particularising particularistic particularities particularizing pasteurizations patentabilities pathogenicities pathophysiology peaceablenesses pectinesterases pendulousnesses penetrabilities pentobarbitones penuriousnesses perdurabilities perfectionistic perfunctoriness peripatetically perishabilities permanentnesses permissibleness perpendicularly persnicketiness personalization personification perspicaciously perspicuousness pervasivenesses pervertednesses pessimistically pestiferousness phantasmagorias pharisaicalness pharmaceuticals pharmacodynamic pharmacognosies pharmacognostic pharmacokinetic pharmacological pharmacologists pharmacotherapy phenobarbitones phenolphthalein phenomenalistic phenomenologies phenomenologist phenylbutazones phenylketonuria phenylketonuric phenylthioureas philanthropical philanthropists philanthropoids philosophically phonocardiogram phonogramically phosphatization phosphocreatine phosphoproteins phosphorescence phosphorylating phosphorylation phosphorylative photoautotrophs photobiological photobiologists photochemically photoconductive photodegradable photodissociate photoduplicated photoduplicates photoelectronic photoengravings photoexcitation photofinishings photogeological photogeologists photogrammetric photoinductions photoionization photojournalism photojournalist photolithograph photomechanical photometrically photomicrograph photomultiplier photooxidations photoperiodisms photoproduction photoreceptions photoreductions photosensitized photosensitizer photosensitizes photosynthesize phototactically phototelegraphy phototoxicities phototropically phototypesetter phrasemongering phthalocyanines physicochemical physiographical physiologically physiopathology physiotherapies physiotherapist phytochemically phytoflagellate phytogeographer phytogeographic phytopathogenic phytoplanktonic phytotoxicities pictorialnesses picturesqueness pigheadednesses pinealectomized pinealectomizes pinheadednesses pinocytotically pithecanthropus plainclothesman plainclothesmen plainspokenness plaintivenesses planimetrically plasticizations platinocyanides platitudinarian platitudinizing platitudinously platyhelminthic plausiblenesses pleasurableness plenipotentiary plenteousnesses plentifulnesses plethysmographs plethysmography pleuropneumonia pluralistically plutocratically pneumonectomies pointlessnesses poliomyelitides politicizations polyacrylamides polycrystalline polyelectrolyte polymerisations polymerizations polymorphically polynucleotides polysaccharides polyunsaturated ponderousnesses popularizations possessednesses postadolescents postapocalyptic postconsonantal postdevaluation postdivestiture posthemorrhagic postinoculation postirradiation postmasterships postmillenarian postoperatively postpollination postproductions poststimulation poststimulatory posttransfusion postvaccination powerlessnesses practicableness practicalnesses prayerfulnesses preadolescences preagricultural prearrangements precancellation precipitantness precipitateness precipitinogens precipitousness preconditioning predestinarians predestinations predevaluations predevelopments predispositions preestablishing prefabrications preferabilities prefiguratively preformationist prehistorically preimplantation preinterviewing prejudicialness prekindergarten premanufactured premanufactures prematurenesses premillenarians premillennially premodification prenotification preperformances preponderancies preponderations prepositionally prepresidential preprofessional prepublications preregistration prerevisionists presentableness preservationist pressurizations prestidigitator prestigiousness presuppositions presynaptically pretentiousness preterminations preternaturally prettifications primitivenesses prioritizations problematically procrastinating procrastination procrastinators professionalism professionalize profitabilities prognosticating prognostication prognosticative prognosticators programmability progressiveness progressivistic progressivities prohibitionists prohibitiveness proletarianised proletarianises proletarianized proletarianizes promiscuousness promotabilities promotivenesses pronunciamentos pronunciational proportionality proportionately proportionating proprietorships proprioceptions proselytization prosopographies prostatectomies prosthodontists proteolytically protohistorians protoporphyrins protozoologists provincialities provincializing provocativeness proximatenesses prussianization pseudepigraphon pseudocoelomate pseudomorphisms pseudopregnancy pseudoscientist pseudoscorpions psychedelically psychiatrically psychoacoustics psychoanalyzing psychobiography psychobiologies psychobiologist psychochemicals psychogenically psychohistorian psychohistories psycholinguists psychologically psychometrician psychoneurotics psychopathology psychophysicist psychosexuality psychosurgeries psychosyntheses psychosynthesis psychotherapies psychotherapist psychotomimetic pulchritudinous punctiliousness punishabilities purposelessness purposivenesses pusillanimities pusillanimously pyroelectricity pyrotechnically quadruplicating quadruplication quadruplicities quantifications quarrelsomeness quarterfinalist quatercentenary querulousnesses quincentenaries quincentennials quintuplicating radicalizations radioactivities radioautographs radioautography radiobiological radiobiologists radiochemically radiometrically radioprotection radioprotective radiostrontiums radiotelegraphs radiotelegraphy radiotelemetric radiotelephones radiotherapists rapaciousnesses rapturousnesses rationalization reacclimatizing reaccreditation reactionaryisms reafforestation reapportionment reappropriating reasonabilities reauthorization recalcitrancies recallabilities recanalizations recapitulations receptivenesses recertification recessivenesses rechoreographed rechromatograph reclusivenesses recodifications recognizability recolonizations recombinational recommencements recommendations recommissioning reconcentrating reconcentration reconceptualize reconcilability reconciliations reconditenesses reconfiguration reconfirmations reconnaissances reconsecrations reconsideration reconsolidating reconstitutions reconstructible reconstructions recontaminating recontamination recontextualize recrystallizing recursivenesses redetermination redintegrations redistillations redistributions reductivenesses reduplicatively reeligibilities reestablishment reflectometries reflexivenesses reformabilities refortification refractometries refrangibleness refundabilities regardfulnesses regionalization regretfulnesses regularizations rehabilitations rehospitalizing reimplantations reincorporating reincorporation reindustrialize reinstallations reintroductions reinvestigating reinvestigation reinvigorations rejuvenescences religiousnesses relinquishments remanufacturers remanufacturing rematerializing remediabilities rememberability remobilizations remonetizations remonstratively remorselessness removablenesses remythologizing renationalizing renormalization reorchestrating reorchestration reorganizations repairabilities repeatabilities repetitiousness rephotographing replicabilities repolarizations reposefulnesses representations representatives repristinations reprivatization reproachfulness reproducibility republicanizing repudiationists repulsivenesses requalification requisitenesses reregistrations resectabilities resentfulnesses reservationists resistibilities resistivenesses resocialization resourcefulness respectableness respiritualized respiritualizes responsibleness restrengthening restrictionisms restrictionists restrictiveness resurrectionist resystematizing retentivenesses retinoblastomas retransmissions retroactivities retrogradations retrogressively retroperitoneal retroreflection retroreflective retroreflectors retrospectively revalorizations reversibilities revisualization revitalizations revivifications revolutionaries revolutionarily revolutionising revolutionizers revolutionizing rheumatologists rhombencephalon ribonucleosides ribonucleotides righteousnesses rigidifications ritualistically roentgenography roentgenologies roentgenologist romanticization roundheadedness rudimentariness rumbustiousness rumormongerings sabermetricians sacramentalisms sacramentalists sacrosanctities sadomasochistic sagaciousnesses salaciousnesses sanctifications sanctimoniously saponaceousness saponifications saprogenicities saprophytically schematizations schistosomiases schistosomiasis schlockmeisters schoolmasterish scintillometers sclerotizations sculpturesquely seaworthinesses seclusivenesses secondarinesses secretivenesses secularizations securitizations sedimentologies sedimentologist seditiousnesses seductivenesses segregationists selectivenesses semiabstraction semicentennials semicolonialism semicrystalline semicylindrical semidocumentary semilogarithmic semipornography semiretirements semisubmersible semiterrestrial semitranslucent semitransparent sensationalised sensationalises sensationalisms sensationalists sensationalized sensationalizes senselessnesses sensitivenesses sensualizations sententiousness sentimentalised sentimentalises sentimentalisms sentimentalists sentimentalized sentimentalizes separablenesses septendecillion septuagenarians serendipitously seroconversions serviceableness servomechanisms sesquicarbonate sesquicentenary shamelessnesses shapelessnesses shiftlessnesses sidesplittingly sightlessnesses sigmoidoscopies silicifications silversmithings silviculturally silviculturists simplifications sinterabilities slaughterhouses sledgehammering sleeplessnesses snippersnappers socialistically sociobiological sociobiologists socioculturally sociohistorical sociolinguistic softheartedness solderabilities solidifications solipsistically solitudinarians solubilizations somnambulations sophisticatedly sophistications sorrowfulnesses specialisations specializations spectrographies spectroscopists spermatogeneses spermatogenesis spinelessnesses spinthariscopes spiritualnesses splendiferously splenectomizing spontaneousness sporangiophores spreadabilities sprightlinesses squeamishnesses squeezabilities stadtholderates stadtholdership standardization standoffishness statelessnesses steadfastnesses steeplechasings stereochemistry stereoisomerism stereologically stereotaxically stereotypically steroidogeneses steroidogenesis stigmatizations stockbrokerages stoichiometries straightforward straightjackets straitjacketing straitlacedness stratifications stratovolcanoes strenuousnesses streptobacillus streptothricins strikebreakings strongyloidoses strongyloidosis structuralizing stultifications stylelessnesses subcategorizing subcontraoctave subdevelopments subinfeudations submetacentrics suboptimization subordinateness suborganization subprofessional subproletariats subreptitiously subspecializing substantialness substantiations substantiveness substantivizing substitutionary subterraneously suburbanization subvocalization succinylcholine sulfinpyrazones sulfurousnesses sumptuousnesses superablenesses superabsorbents superabundances superabundantly superactivities superannuations superbureaucrat supercalendered superconducting superconductive superconductors supercontinents superconvenient superefficiency superelevations superenciphered supererogations superfluidities superfluousness supergovernment superheterodyne superhumanities superimposition superindividual superinductions superinfections superintendence superintendency superintendents superlativeness supermajorities supernaturalism supernaturalist supernumeraries supernutritions superovulations superparasitism superpatriotism superphenomenon superphosphates superplasticity supersaturating supersaturation superscriptions superspecialist superspectacles superstimulated superstimulates superstitiously superstructural superstructures supersubtleties supersymmetries supplementation suppressibility suppressiveness surreptitiously survivabilities susceptibleness suspensefulness swellheadedness sycophantically syllabification syllogistically symmetricalness symmetrizations sympathectomies sympathetically sympathomimetic symptomatically symptomatologic synchronicities synchronisation synchronization synchronousness synecdochically synergistically systematization tachyarrhythmia talkativenesses tarsometatarsus tastelessnesses tatterdemalions teachablenesses technologically technostructure telangiectasias teleconferenced teleconferences telegraphically telekinetically telephotography teleprocessings teletypewriters temerariousness temperamentally temperatenesses tempestuousness temporarinesses tenaciousnesses tendentiousness tenderheartedly tenosynovitises tentativenesses teratocarcinoma tergiversations territorialisms territorialists territorialized territorializes tetragrammatons tetrahydrofuran tetramethyllead thalassocracies thanklessnesses theatricalities theatricalizing therapeutically thermalizations thermochemistry thermodynamical thermojunctions thermoperiodism thermoreceptors thermoregulated thermoregulates thermoregulator thermoremanence thermostability thinkablenesses thoughtlessness thromboembolism thromboplastins thunderstricken thunderstriking thyrocalcitonin thyroidectomies tightfistedness toastmistresses tomboyishnesses tonsillectomies toothsomenesses topographically totalitarianism totalitarianize toxicologically tractablenesses traditionalisms traditionalists traditionalized traditionalizes transaminations transcendencies transcriptional transferability transfiguration transformations transhistorical transilluminate transistorising transistorizing translatability transliterating transliteration transmigrations transmissometer transmogrifying transparentized transparentizes transparentness transpirational transplantation transportations transpositional transsexualisms transubstantial transvaluations traumatizations treacherousness tremulousnesses triangularities trichomonacidal trichomonacides trifluoperazine trigonometrical trihalomethanes trinitrotoluene trisoctahedrons trivializations troubleshooters troubleshooting troublesomeness troublousnesses trueheartedness trustworthiness trypanosomiases trypanosomiasis turbogenerators typographically tyrannosauruses ultimogenitures ultracentrifuge ultracommercial ultraconvenient ultrademocratic ultrafastidious ultrafiltration ultraliberalism ultramarathoner ultramicroscope ultramicrotomes ultramodernists ultramontanisms ultraprecisions ultrasonography ultrastructural ultrastructures ultravirilities unacceptability unaccommodating unadulteratedly unalterableness unanswerability unanticipatedly unappreciations unassailability unboundednesses uncategorizable unceremoniously uncertainnesses unchallengeable unchangeability unchoreographed unchronological uncircumcisions uncleanlinesses unclimbableness uncommunicative uncompassionate uncomplainingly uncomplimentary uncomprehending uncompromisable unconcernedness unconditionally unconsciousness uncontroversial uncopyrightable undemonstrative underactivities underemphasized underemphasizes underemployment underestimating underestimation underhandedness underinflations underinvestment undernutritions underprivileged underproduction underpublicized understandingly understatements undervaluations undesirableness undistinguished undutifulnesses unearthlinesses unemployability unendurableness unexceptionable unexceptionably unextraordinary unfamiliarities unfavorableness unfeelingnesses unforgivingness unfossiliferous unguardednesses unhealthinesses uniformitarians unimaginatively uninformatively uninhibitedness unintelligently unintentionally uninterruptedly universalnesses unknowabilities unknowledgeable unmelodiousness unmitigatedness unnaturalnesses unobjectionable unobtrusiveness unparliamentary unprecedentedly unprepossessing unpretentiously unprofessionals unpronounceable unpunctualities unquestioningly unrealistically unreconstructed unreliabilities unrevolutionary unrighteousness unselfishnesses unseriousnesses unsettlednesses unsightlinesses unsociabilities unsophisticated unsportsmanlike unsubstantially unsubstantiated unsuitabilities unsymmetrically untraditionally unwillingnesses unworkabilities unworldlinesses upgradabilities utilitarianisms valetudinarians valuelessnesses vascularization vasoconstrictor vasodilatations venerablenesses ventriloquially ventriloquistic ventriloquizing venturesomeness venturousnesses veraciousnesses verifiabilities verisimilitudes veritablenesses versatilenesses vexatiousnesses vicariousnesses vicissitudinous videoconference viscoelasticity visionarinesses vivaciousnesses vivisectionists voicelessnesses volatilizations voluntarinesses voraciousnesses voyeuristically vulnerabilities wappenschawings warmheartedness warrantableness waterlessnesses wearisomenesses weatherboarding weatherizations weatherproofing weltanschauungs westernisations westernizations whatchamacallit whimsicalnesses whippersnappers whistleblowings wholesomenesses withdrawnnesses woebegonenesses wonderfulnesses worrisomenesses worthlessnesses wrongheadedness xerographically xeroradiography zoogeographical
What is the highest possible length of a word?¶
In [30]:
ans = 0
for i in df.index:
if len(i) > ans:
ans = len(i)
ans
Out[30]:
28
What is the word with the value of 319?¶
In [56]:
df[df['Value'] == 319]
Out[56]:
| Char Count | Value | |
|---|---|---|
| Word | ||
| reinstitutionalizations | 23 | 319 |
What is the most common value?¶
In [142]:
df['Value'].unique
Out[142]:
<bound method Series.unique of Word
aa 2
aah 10
aahed 19
aahing 40
aahs 29
...
zymotic 111
zymurgies 143
zymurgy 135
zyzzyva 151
zyzzyvas 170
Name: Value, Length: 172821, dtype: int64>
What is the shortest word with value 274?¶
In [66]:
df[df['Value'] == 274]
Out[66]:
| Char Count | Value | |
|---|---|---|
| Word | ||
| countercountermeasure | 21 | 274 |
| overprotectivenesses | 20 | 274 |
| psychophysiologically | 21 | 274 |
Create a column Ratio which represents the 'Value Ratio' of a word¶
In [70]:
df['Ratio'] = df['Value'] / len('Word')
In [73]:
df1 = df.head()
In [84]:
df1['Value'][0]
/tmp/ipykernel_17/88607661.py:1: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]` df1['Value'][0]
Out[84]:
2
In [98]:
df1.index.values
Out[98]:
array(['aa', 'aah', 'aahed', 'aahing', 'aahs'], dtype=object)
In [109]:
df1.drop(['Ratio', 'Value Ratio'], inplace=True, axis=1)
/tmp/ipykernel_17/3495083398.py:1: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy df1.drop(['Ratio', 'Value Ratio'], inplace=True, axis=1)
In [110]:
df1
Out[110]:
| Char Count | Value | |
|---|---|---|
| Word | ||
| aa | 2 | 2 |
| aah | 3 | 10 |
| aahed | 5 | 19 |
| aahing | 6 | 40 |
| aahs | 4 | 29 |
In [118]:
df['Ratio'] = df['Value'] / df['Char Count']
In [116]:
for i in df1.index:
print(df.loc[i])
Char Count 2.0 Value 2.0 Value Ratio 0.5 Ratio 0.5 Name: aa, dtype: float64 Char Count 3.0 Value 10.0 Value Ratio 2.5 Ratio 2.5 Name: aah, dtype: float64 Char Count 5.00 Value 19.00 Value Ratio 4.75 Ratio 4.75 Name: aahed, dtype: float64 Char Count 6.0 Value 40.0 Value Ratio 10.0 Ratio 10.0 Name: aahing, dtype: float64 Char Count 4.00 Value 29.00 Value Ratio 7.25 Ratio 7.25 Name: aahs, dtype: float64
What is the maximum value of Ratio?¶
In [124]:
df['Ratio'].max()
Out[124]:
22.5
What word is the one with the highest Ratio?¶
In [128]:
df[df['Ratio'] == df['Ratio'].max()].index[0]
Out[128]:
'xu'
How many words have a Ratio of 10?¶
In [130]:
len(df[df['Ratio'] == 10])
Out[130]:
2604
What is the maximum Value of all the words with a Ratio of 10?¶
In [133]:
df[df['Ratio'] == 10]['Value'].max()
Out[133]:
240
Of those words with a Value of 260, what is the lowest Char Count found?¶
In [134]:
df[df['Value'] == 260]['Char Count'].min()
Out[134]:
17
Based on the previous task, what word is it?¶
In [162]:
indexes = df[df['Value'] == 260]['Char Count'].index
for i in indexes:
if df[i]['Chat Count'] == 17:
print(df[i])
--------------------------------------------------------------------------- KeyError Traceback (most recent call last) File /usr/local/lib/python3.11/site-packages/pandas/core/indexes/base.py:3805, in Index.get_loc(self, key) 3804 try: -> 3805 return self._engine.get_loc(casted_key) 3806 except KeyError as err: File index.pyx:167, in pandas._libs.index.IndexEngine.get_loc() File index.pyx:196, in pandas._libs.index.IndexEngine.get_loc() File pandas/_libs/hashtable_class_helper.pxi:7081, in pandas._libs.hashtable.PyObjectHashTable.get_item() File pandas/_libs/hashtable_class_helper.pxi:7089, in pandas._libs.hashtable.PyObjectHashTable.get_item() KeyError: 'countermobilizations' The above exception was the direct cause of the following exception: KeyError Traceback (most recent call last) Cell In[162], line 3 1 indexes = df[df['Value'] == 260]['Char Count'].index 2 for i in indexes: ----> 3 if df[i]['Chat Count'] == 17: 4 print(df[i]) File /usr/local/lib/python3.11/site-packages/pandas/core/frame.py:4102, in DataFrame.__getitem__(self, key) 4100 if self.columns.nlevels > 1: 4101 return self._getitem_multilevel(key) -> 4102 indexer = self.columns.get_loc(key) 4103 if is_integer(indexer): 4104 indexer = [indexer] File /usr/local/lib/python3.11/site-packages/pandas/core/indexes/base.py:3812, in Index.get_loc(self, key) 3807 if isinstance(casted_key, slice) or ( 3808 isinstance(casted_key, abc.Iterable) 3809 and any(isinstance(x, slice) for x in casted_key) 3810 ): 3811 raise InvalidIndexError(key) -> 3812 raise KeyError(key) from err 3813 except TypeError: 3814 # If we have a listlike key, _check_indexing_error will raise 3815 # InvalidIndexError. Otherwise we fall through and re-raise 3816 # the TypeError. 3817 self._check_indexing_error(key) KeyError: 'countermobilizations'
In [163]:
df[df['Value'] == 260]['Char Count']
Out[163]:
Word countermobilizations 20 hydroxytryptamine 17 neuropsychologists 18 psychophysiologist 18 revolutionarinesses 19 underrepresentations 20 Name: Char Count, dtype: int64
In [ ]:
