Intro to Pandas for Data Analysis

# DataFrames practice: working with English Words

In this project you'll use several skills related to DataFrames to create new columns, analyze a DataFrame and answer questions about the dataset we're using: a huge list of words of the English Language.
Project Created by

## Project Activities

All our Data Science projects include bite-sized activities to test your knowledge and practice in an environment with constant feedback.

All our activities include solutions with explanations on how they work and why we chose them.

input

### How many elements does this dataframe have?

Basically, how many words have we read from the file?

input

input

multiplechoice

input

input

### What is the word with the value of `319`?

The word `microspectrophotometries` is the only word with a value of `317`. Find the only word with a value of `319`:

input

### What is the most common value?

There are `1921` words with a value of `100`, making it the second most common letter sum. What value is most common?

input

codevalidated

### Create a column `Ratio` which represents the 'Value Ratio' of a word

The "Value Ratio" of a word is defined as the `Value` of a word divided by its length. That is: `ValueRatio(word) = Value(word) / len(word)`.

Create a new column in your DataFrame named `Ratio` that contains such computation.

input

input

### What word is the one with the highest `Ratio`?

In the previous activity you compute the maximum `Ratio`. Now answer, which word has such `Ratio`?

input

input

input

input

### Based on the previous task, what word is it?

What word has a `Value` of `260` and has the lowest `Char Count`?

Project Created by

#### Santiago Basulto

This project is part of

## Intro to Pandas for Data Analysis

Explore other projects