Create a data frame and load the excel or csv file

Assignment Help Computer Engineering

Reference no: EM133663807

Assignment

Using Pandas to access data with Excel or CSV files. Use your approved dataset for this assignment.

Requirements I

Import the pandas library
Import the numpy library
Import the openpyxl library

Create a data frame and load the Excel or CSV file

Add the optional settings
pd.set_option("display.max_columns",None)
pd.set_option("display.max_rows",None)
pd.set_option("max_colwidth",None)
pd.set_option('expand_frame_repr',False)

Requirements II

Print all the columns in the data frame
Print a statistic summary of the data frame
Print the first 4 records in the data frame
Print the last 7 records in the data frame

Requirements III

Print the index in the data frame
Print the data types in the data frame
Selecting Data with brackets []
Print any column in the data frame
Print the 3rd data element using an index for your selected column

Requirements IV

Create a new numeric column (default: zero)
Create a temp dataset with your main dataset
Using a for loop:
Using a function (insert parameter):
Perform arithmetic with one of your numeric fields
Store the result in your new numeric column
Print the first 5 records in the data frame
Save the data into a csv file (Make sure your name is in the file title)

Requirements V

Create a filter using two of your columns from your dataset
Create a temp dataset with your main dataset and filter
Print the first 5 records in the data frame
Save the data into a csv file (Make sure your name is in the file title)

Requirements VI

Create a new numeric column (default: zero)
Create another function (insert parameter) to perform arithmetic
Append a row to the main dataset; use the function to populate the numeric column created earlier
Save the data into a csv file (Make sure your name is in the file title)
Open the file and highlight the row you added

Requirements VII

Create a new numeric column (default: negative -1)
Create a temp dataset with your main dataset
Using a for loop:
Using if statements:
Populate categorical codes in the numeric column
Print the first 5 records in the data frame
Save the data into a csv file (Make sure your name is in the file title)

Reference no: EM133663807

Questions Cloud

Describe the role of the world wide web consortium : Describe the role of the World Wide Web Consortium (W3C) in defining web standards and Research the history of the World Wide Web

Briefly about evaluation plan : Develop a discussion that informs briefly about an evaluation plan and context of a program and ultimately how it would be used by either program clients

While employer reasonably accommodates : While an employer reasonably accommodates an employee's religious conflict, it is the duty of the employee to

Comprehensive review of the reference materials : Comprehensive review of the reference materials you have utilised - Individual Cover Page with the students Identification (Name and Student Number)

Create a data frame and load the excel or csv file : Create a data frame and load the Excel or CSV file. Create a temp dataset with your main dataset. Perform arithmetic with one of your numeric fields.

Identify potential sources of information that can be used : CT 421- Identify potential sources of information that can be used to develop and support ideas. Identify the problem to be solved.

What is the main function of the mitochondria : What is the main function of the mitochondria within the cells - what would be your hypothesis on how this can happen knowing the function of the mitochondria

What the attacker did stole and wanted : BIS 3004- What the attacker(s) did, stole and wanted? Did organisation pay anything because of the attack? What action did they adopt to avoid further damage?

Job description for entry-level store employee : Use the table below to draft a job description for an Entry-level Store Employee.

User Account

All Pages