Scribd
Upload
66 views1 page

Python Assessment 1

The document outlines an assessment for Python and Data Analytics involving the creation of a sample CSV file for car specifications and an Excel file for car pricing and loan details. It includes tasks such as reading the files into data frames, merging them, handling missing values, and calculating GST for pricing. References to the pandas documentation are provided for guidance on using the library.

Uploaded by

CST A69 Trisha Nandy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
66 views1 page

Python Assessment 1

The document outlines an assessment for Python and Data Analytics involving the creation of a sample CSV file for car specifications and an Excel file for car pricing and loan details. It includes tasks such as reading the files into data frames, merging them, handling missing values, and calculating GST for pricing. References to the pandas documentation are provided for guidance on using the library.

Uploaded by

CST A69 Trisha Nandy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Python & Data Analytics Assessment 1

1. Prepare the sample csv file for car model and their specification, the column names would be

a. Company Name

b. Model Name

c. Fuel Type (For e.g. Petrol, Gas, Diesel, EV)

d. Body Style (for e.g. Hatchback, Sedan, SUV)

e. Car Length

2. Prepare the sample excel file for the car prizing and loan amount, the column names would be

a. Company Name

b. Model Name

c. On road pricing

d. Loan amount

e. Monthly EMI

f. Interest Rate

g. Monthly Principal

h. Monthly Interest

3. Write the code to read the csv file and the excel file and convert them into the Data frame.

4. Merge the two Data frame on the basis of primary key

5. Fill the “NA” values in the merged data frame

6. Iterate over the merged Data frame and add the GST value in the “On road pricing” column

Reference

1. Getting started — pandas 2.0.0 documentation (pydata.org)


2. pandas.DataFrame — pandas 2.0.0 documentation (pydata.org)
3. General functions — pandas 2.0.0 documentation (pydata.org)

You might also like