Tutorial- 2 - Pandas

  • Due Dec 31, 2023 by 11:59pm
  • Points 10
  • Submitting a file upload
  • File Types doc, pdf, and ipynb
  • Available Dec 27, 2022 at 12pm - Mar 31, 2024 at 11:59pm over 1 year
This assignment was locked Mar 31, 2024 at 11:59pm.

Tutorial : 2 - Explore Pandas library to analyse and manipulate data.

  1. Import NumPy and pandas library.
  2. Define series with 3 elements.
  3. Define series with custom index.
  4. Fetch Series value and index.
  5. Create DataFrame from list of Dict.
  6. Create dataframe with some missing value - NaN(Not a Number) represents missing values.
  7. Read excel file.
  8. Explore kaggle.com for dataset. Search iris dataset and download.
  9. Read iris dataset from csv file format and findout no. of rows and columns.
  10. Perform following operation on iris dataset.
    1. Fetch firat 5 and last 5 rows.
    2. Find index
    3. remane columns
    4. replace "Iris-versicolor" with "versicolor"
    5. Find Statistical description
    6. extract specific column
    7. add new column with condition
    8. drop added column
    9. select first row data
    10. select 51 to 55 rows
    11. Apply conditional formatting
    12. replace "Iris-versicolor" with "versicolor"
    13. print "virginica" with "Petal_Length" more then 6
    14. find duplicate values
    15. Find basic information

****************************************************************************************

1704047340 12/31/2023 11:59pm