Tutorial 4 - Pandas Advanced

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

how we can get more information about the data with the function describe ?

.describe(include."all")

what i need to do in order to know if the value is Nan or not ?

.isna

what are the 4 things that importnt to do in our initial data exploration ?

.shape .head .info .describe

what the function dropna() does ?

The dropna() method drops all rows in which we have a missing value,

what is the function agg()?

method is a function in Python's pandas library that is used to perform aggregation operations on DataFrame or Series objects.

how we can change the defult sperater in a file reading ?

sep = "new separator"

what the function groupby() is doing?

diding the data into group by the input that you give the function

why the function dropna() can be dengoures ?

in our case it's risky, since the entire 'video_release_date' has missing values, so if we will use the dropna() method it will drop the entire dataset. To avoid this we can specify the columns on which we want to use the dropna() method using the subset parameter:

What are the tree things we need to check about our data before we do anything with her ?

Does the file includes an index column? Does the file includes a first row of column names or we have to create them manually? Does the file uses the default separator (',')?

how can i reshape this data ? temperature_data_dict = { 'Day' : ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'], 'Haifa': [30, 29, 28, 29, 30, 31, 32], 'Tel-Aviv': [28, 27, 27, 28, 29, 30, 31], 'Beersheva': [32, 32, 31, 31, 31, 33, 34] }

df = pd.DataFrame(temperature_data_dict)

How to import pandas

import pandas as pd


Ensembles d'études connexes

(C) Name the tissue or part of the body contained in the following terms and give the meaning of the entire term.

View Set

CH. 16 Psych, General psych study guide 14, 16

View Set

A Global View of Operations and Supply Chains

View Set

Person Centered Therapy, Existential Therapy, Gestalt Therapy, Chapter 8 Gestalt Therapy Questions, Psychoanalytic Theory/Gestalt/Existential/Person Centred/ Ethical Issues in Counseling Practice

View Set

exam 5- metabolism/cellular regulation

View Set

CH. 11 Assessing CULTURE 3060 Health Assessment

View Set

Crime Scene Follow-up Investigations

View Set

Finding Circumference and Area of a Circle Practice

View Set