Basic Operations on Data using Pandas - Python

 

EVENT MANAGEMENT - VII

Event Management - VII
 


Sunil the event manager found that using some functionalities of Data science, it was possible to generate the descriptive statistics, the transpose of the data set also to sort the data set according to a particular column or value.
 
He provides his requirement to the development team. Now you being the part of the team, this requirement is assigned to you.
 
Write a code to describe, transpose and sort the data set.
 
Input Format:
The input consists of a CSV file containing the data set of 10 rows and 10 columns followed by the choice (1/2/3/4) entered by the user.
 
The choice 1 corresponds to describe the 'NoOfDates','Expected Audience','HallPricePerDay','TotalCost' columns  in the dataset.
The choice 2 corresponds to transpose the data set.
The choice 3 corresponds to sort the data set by axis(0 or 1).
The choice 4 corresponds to sort the data set by value.
 
Output format:
The output displays the data set after altering it according to the choice entered by the user.
 
Sample Input -Output 1:
1)Description

2)Transpose the data
3)Sort by axis
4)Sort by Value
Enter your choice
4
Enter the column name
EventName
+----+---------+------------------------+----------------+-------------+-------------+------------+---------------------+-------------------------+--------------------------------------------------+-------------------+-------------+
|    |   Sl_No | EventName              | EventManager   |   NoOfDates | StartDate   | EndDate    |   Expected Audience | HallName                | HallAddress                                      |   HallPricePerDay |   TotalCost |
|----+---------+------------------------+----------------+-------------+-------------+------------+---------------------+-------------------------+--------------------------------------------------+-------------------+-------------|
|  1 |       2 | Birthday Celebration   | Akshay         |           1 | 14-08-2005  | 14-08-2005 |                 nan | Akshayalaya             | Akshayalaya, Akshaya Dama,Yogendra Nagar,Shimoga |             35000 |       35000 |
|  8 |       9 | Birthday Celebration   | Akshay         |           1 | 14-08-2005  | 14-08-2005 |               10000 | Akshayalaya             | Akshayalaya, Akshaya Dama,Yogendra Nagar,Shimoga |             35000 |       35000 |
|  6 |       7 | Chrismas Celebration   | Collin         |           2 | 24-12-2005  | 25-12-2005 |                1500 | Saint Philominas chruch | Mysore                                           |             25000 |       50000 |
|  2 |       3 | House Warming          | sunil          |           1 | 21-10-2005  | 21-10-2005 |                1000 | Sugamya Corner          | sugamya corner ,Vijaya nagar,Mysore              |             50000 |       50000 |
| 10 |      11 | Marraige               | krishnanand    |           1 | 15-08-2005  | 16-08-2005 |               25000 | krishna mansion         | Krishna Mansion ,Krishnalaya,Shringeri           |             60000 |       60000 |
|  3 |       4 | Naming Ceremony        | Surya          |           1 | 10-11-2005  | 10-11-2005 |                1500 | Suryodaya comforts      | Suryodaya comforts,Srirampura                    |             20000 |       20000 |
|  5 |       6 | New Year Celebration   | Chandan v      |         nan | 31-12-2005  | 01-12-2005 |                 700 | Chinnaswammy stadium    | Bangalore                                        |             12000 |       24000 |
|  7 |       8 | Project outing         | Yaradru        |           2 | nan         | 30-11-2005 |                  25 | Lalth Mahal Palace      | Mysore                                           |             15000 |       30000 |
|  4 |       5 | Promossion Celebration | Aliya          |           1 | 15-11-2005  | 15-11-2005 |                 250 | Kabule convention hall  | Nr Mohalla,Mysore                                |             20000 |       20000 |
|  9 |      10 | Reception              | krishnanand    |           2 | 12-08-2005  | 13-08-2005 |               25000 | krishna mansion         | Krishna Mansion ,Krishnalaya,Shringeri           |             60000 |      120000 |
|  0 |       1 | nan                    | krishnanand    |           2 | 12-08-2005  | 13-08-2005 |               20000 | krishna mansion         | Krishna Mansion ,Krishnalaya,Shringeri           |             60000 |      120000 |
+----+---------+------------------------+----------------+-------------+-------------+------------+---------------------+-------------------------+--------------------------------------------------+-------------------+-------------+

Sample Input - Output 2:
1)Description
2)Transpose the data
3)Sort by axis
4)Sort by Value
Enter your choice
3
Enter the axis to be sorted
1
 +----+------------+----------------+------------------------+---------------------+--------------------------------------------------+-------------------------+-------------------+-------------+---------+-------------+-------------+
| | EndDate | EventManager | EventName | Expected Audience | HallAddress | HallName | HallPricePerDay | NoOfDates | Sl_No | StartDate | TotalCost |
|----+------------+----------------+------------------------+---------------------+--------------------------------------------------+-------------------------+-------------------+-------------+---------+-------------+-------------|
| 0 | 13-08-2005 | krishnanand | nan | 20000 | Krishna Mansion ,Krishnalaya,Shringeri | krishna mansion | 60000 | 2 | 1 | 12-08-2005 | 120000 |
| 1 | 14-08-2005 | Akshay | Birthday Celebration | nan | Akshayalaya, Akshaya Dama,Yogendra Nagar,Shimoga | Akshayalaya | 35000 | 1 | 2 | 14-08-2005 | 35000 |
| 2 | 21-10-2005 | sunil | House Warming | 1000 | sugamya corner ,Vijaya nagar,Mysore | Sugamya Corner | 50000 | 1 | 3 | 21-10-2005 | 50000 |
| 3 | 10-11-2005 | Surya | Naming Ceremony | 1500 | Suryodaya comforts,Srirampura | Suryodaya comforts | 20000 | 1 | 4 | 10-11-2005 | 20000 |
| 4 | 15-11-2005 | Aliya | Promossion Celebration | 250 | Nr Mohalla,Mysore | Kabule convention hall | 20000 | 1 | 5 | 15-11-2005 | 20000 |
| 5 | 01-12-2005 | Chandan v | New Year Celebration | 700 | Bangalore | Chinnaswammy stadium | 12000 | nan | 6 | 31-12-2005 | 24000 |
| 6 | 25-12-2005 | Collin | Chrismas Celebration | 1500 | Mysore | Saint Philominas chruch | 25000 | 2 | 7 | 24-12-2005 | 50000 |
| 7 | 30-11-2005 | Yaradru | Project outing | 25 | Mysore | Lalth Mahal Palace | 15000 | 2 | 8 | nan | 30000 |
| 8 | 14-08-2005 | Akshay | Birthday Celebration | 10000 | Akshayalaya, Akshaya Dama,Yogendra Nagar,Shimoga | Akshayalaya | 35000 | 1 | 9 | 14-08-2005 | 35000 |
| 9 | 13-08-2005 | krishnanand | Reception | 25000 | Krishna Mansion ,Krishnalaya,Shringeri | krishna mansion | 60000 | 2 | 10 | 12-08-2005 | 120000 |
| 10 | 16-08-2005 | krishnanand | Marraige | 25000 | Krishna Mansion ,Krishnalaya,Shringeri | krishna mansion | 60000 | 1 | 11 | 15-08-2005 | 60000 |
+----+------------+----------------+------------------------+---------------------+--------------------------------------------------+-------------------------+-------------------+-------------+---------+-------------+-------------+



Solution :

import pandas as pd
from tabulate import tabulate


def pprint_df(dframe):
 print(tabulate(dframe, headers='keys', tablefmt='psql', showindex=True))

print("1)Description\n2)Transpose the data\n3)Sort by axis\n4)Sort by Value\nEnter your choice")

n=int(input())
df=pd.read_csv("Event_Management_system.csv")

if(n==1):pprint_df(df.drop(["Sl_No"],axis=1).describe())    
elif(n==2):pprint_df(df.transpose())
elif(n==3):pprint_df(df.sort_index(axis = int(input("Enter the index to be sorted\n"))))
elif(n==4):pprint_df(df.sort_values(by=[input("Enter the column name\n")]))

Comments

Post a Comment

Popular posts from this blog

2-D Arrays

Image
S7P1 - VALID INITIAL CONFIGURATION Valid Initial Configuration   Nurikabe logical game (sometimes called Islands in the Stream) is a binary determination puzzle. The puzzle is played on a typically rectangular grid of cells, some of which contain numbers. You must decide for each cell if it is white or black (by clicking on them) according to the following rules: All of the black cells must be connected. Each numbered cell must be part of a white island of connected white cells. Each island must have the same number of white cells as the number it contains (including the numbered cell). Two islands may not be connected. There cannot be any 2x2 blocks of black cells. Unnumbered cells start out grey and cycle through white and black when clicked. Initially numbered cells are white in color. Problem Statement: Write a program to check whether the given board configuration is a valid initial configuration. Below figure is the sample valid initial configuration.   I...
Read more

String

S8P1-ALTERNATING CODE Alternating Code It is IPL Season and the first league match of Dhilip’s favorite team, "Chennai Super Kings". The CSK team is playing at the IPL after 2 years and like all Dhoni lovers, Dhilip is also eagerly awaiting to see Dhoni back in action. After waiting in long queues, Dhilip succeeded in getting the tickets for the big match. On the ticket, there is a letter-code that can be represented as a string of upper-case Latin letters. Dhilip believes that the CSK Team will win the match in case exactly two different letters in the code alternate. Otherwise, he believes that the team might lose. Please see note section for formal definition of alternating code. You are given a ticket code. Please determine, whether CSK Team will win the match or not based on Dhilip’sconviction. Print "YES" or "NO" (without quotes) corresponding to the situation. Note: Two letters   x, y   where   x != y   are said to be alternating in a co...
Read more

Conditional Statements

It was Christmas Eve and the celebrations remembering the birth of Jesus were going on in full swing at the Catheral Chapel. The Event Management Team had arranged for some exciting games after the mass worship and feast, where adults and kids of all ages participated very actively. "Chocolate Game" was organized for the kids which involved a standard chocolate of   n   by   m   pieces. More formally, chocolate is a rectangular plate consisting of n rows and m columns. Two kids at a moment will play with the chocolate. First kid takes the chocolate and cuts it into two parts by making either a horizontal or vertical cut. Then, the second kid takes one of the available pieces and divides into two parts by either making a horizontal or vertical cut. Then the turn of first kid comes and he can pick any block of the available chocolates and do the same thing again. The player who cannot make a turn loses. Write a program to find which of the kids will win if both o...
Read more