Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PROGRAM: READ CSV FILES INTO PANDAS DATAFRAMES USING PYTHON. Create a program in python using pandas dataframe. Program should be able to read a folder

PROGRAM: READ CSV FILES INTO PANDAS DATAFRAMES USING PYTHON.

Create a program in python using pandas dataframe. Program should be able to read a folder of csv files( one should be able to change the path to indicate the folder) and insert them into one new Pandas Dataframe. All csvs have the same columns. Every csv file in the folder must be added to the dataframe as an individual row. This will be done by taking the mean of every column in every file. Example: If your csv folder has 20 csv files and each file has 100 rows and 8 columns. The final data frame should have 20 rows and 8 columns, every row indicating the mean of the columns on each file.

Create functions to:
-Add and remove desired colums and rows.
-Take mean of each column in each file.
-One file in the folder should equal one row in the new data frame.
-Add index column as the name of the file in the folder. (each row is identified by its file name in the folder)
-Create a function to take the max values of column. (Just create, no need to implement)


Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Performance Engineering 10th European Workshop Epew 2013 Venice Italy September 17 2013 Proceedings

Authors: Maria Simonetta Balsamo ,William Knottenbelt ,Andrea Marin

2013 Edition

3642407242, 978-3642407246

More Books

Students also viewed these Programming questions