  ### 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 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.

##### How many elements does this dataframe have?

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

input
input
input
multiplechoice
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
input
##### 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.

codevalidated
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`?

input  Author

# This Project is part of our

Intro to Pandas for Data Analysis

# Skill Track

Explore other projects   Anurag Verma   Anurag Verma