DataScience Classroomnotes 06/Jul/2022

Pandas contd…

  • Pandas can import various file types like excel or csv etc
  • By default Pandas will add an index_col
  • We can point out any column while reading the data as index_col
    Preview

Manipulate Data Frame

  • Lets assign the Dataframe to a variable and perform some basic operations
    Preview
    Preview
    Preview
    Preview
    Preview
    Preview
  • We can extract a series from a Data frame
    Preview
  • Filtering the Column by one or more criteria
    Preview
    Preview
    Preview
    Preview
    Preview
    Preview
    Preview
  • Note:
# Downloading CSV From Powershell
Invoke-WebRequest -URI https://raw.githubusercontent.com/khajadatascienceR/DataScienceWithPython/main/Jun22/Refresher/Pandas/netflix_titles.csv -OutFile 'netflix.csv'

# Downloading CSV from gitbash/mac terminal 
curl https://raw.githubusercontent.com/khajadatascienceR/DataScienceWithPython/main/Jun22/Refresher/Pandas/netflix_titles.csv -o netflix_titles_test.csv

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner