How to install Jupyter notebook and pandas on mobile android ios. Basic data analysis on phone

Опубликовано: 13 Июль 2026
на канале: JasperZeroes

Basic Data Analysis operations using Pandas.

1. View names of columns in a table.

To view the names of columns on a table such as an excel file, use the command;

df.columns

Let's say we have an excel file with 2 column names ; "state" and "city".

If you type the command : df.columns in your Jupyter notebook, the output will be ;

[ "State", "City"]

2. Number of rows

To check the number of rows in an excel file, use the command ;

len(df)

This command will output a number, showing you the total length of the excel file.

3. Number of rows and columns

To check the number of rows and columns in an excel file; use the command ;

df.shape

This will output two numbers. The first number showing the number of rows and the second number for the columns.

Let's say we have an excel file with 20 rows and 2 columns. If you enter the command "df.shape", it will output
(20, 2).

4. Selecting a particular column

To select a particular column from your excel, use the command;

df["column_name"] or
df.column_name

Let's say we have an excel file with two columns namely ; "State" and "City", and you want to select only the State, you use the command

df["City"] or df.City

And it will show only data for "City".

5. Adding new columns to our table.

Using our two column table example, let's say you want to add a third column to it, use the command

df["new_column_name"] = df["Column_1"] + df["Column_2"]

Let's say we want to add a third column, called "State_City", to our dataframes (df), use the command

df["State_City"] = df["State"] + df["City"]

So you'll now have 3 columns instead of two namely:
State
City
State_City

6. Filter data based on condition

Let's say the column "State" in our dataframes has 20 data for Abuja, 10 for Lagos, 13 for Delta and 16 for Port Harcourt. And you want to view data for *Delta state only*, use this command

df[df["State"] == "Delta"]

This will produce only data belonging to Delta state.

If you have any questions, drop in the comment section.

See you in my next class.