Dropping Columns and Changing the index of a dataframe - Python

 Event Management System II- Eliminate Column

 
Sunil, an event manager found his data set was cleaned by the development team and was as required. He also found that his data set was cleaned based on the missing values in rows. He thought it would be helpful if the data set was cleaned based on columns.

So, he requests the development team to do the needful. Assume that you are currently working under development team. Frame a dataset (having 10 rows and 10columns of data) for Event Management System. Consider the threshold as all values should be available, (ie. all the values should be available in a column.) If any value is missing, then drop the particular column.


Input Format:
Create a CSV file containing the data set of 10 rows and 10 columns.

NOTE:
CSV File contains the comma seperated values as shown below.
[SlNo,EventName,EventManager,NoOfDates,StartDate,EndDate,HallName,HallAddress,HallPricePerDay,TotalCost]

Output Format:
 The output should display the data after dropping the rows with missing values from the data set. 

[Refer Sample Input and Output format for format specifications. All text in bold correspond to Input and rest correspond to output.]


Sample Input:
EventManagementSystem.csv

HINT: The EventManagementSystem.csv file can contain the data in the following format.
 
EventName                         EventManager NoOfDays       StartDate        EndDate      HallName                          HallAddress                                                                   HallPricePerDay TotalCost
                                                krishnanand             2                    12-08-2005 13-08-2005 Krishna mansion           Krishna Mansion, Krishnalaya, Shringeri                  60000                    120000
Birthday Celebration Akshay                           1                     14-08-2005 14-08-2005 Akshayalaya                   Akshayalaya, Akshaya Dama, Shimoga                 35000                     35000
House Warming              Sunil                             1                     21-10-2005 21-10-2005 Sugamya Corner          Sugamya corner, Vijaya Nagar, Mysore                  50000                     50000
Naming Ceremony         Surya                          1                     10-11-2005 10-11-2005 Suryodaya comforts     Suryodaya comforts, Srirampura                             20000                     20000
Promotion Celebration Aliya                            1                     15-11-2005 15-11-2005 Kabule convention hall                                                                                                 20000                     20000
New Year Celebration Chandan                   2                     31-12-2005 01-12-2005 Chinnaswamy stadium      Bangalore                                                                     12000                      24000
Chrismas Celebration Collin                            2                    24-12-2005 25-12-2005 Saint Philominas church   Mysore                                                                             25000                      50000
Project outing                  Yaradru                      2                    29-11-2005 30-11-2005 Mysore Palace                       Mysore                                                                                                              15000


Sample Output:
 
+----+-------+----------------------+------------+-------------------------+--------------------------------------------------+-----------------+-----------+
|    | Sl_No |     EventManager     |  EndDate   |         HallName        |                   HallAddress                    | HallPricePerDay | TotalCost |
+----+-------+----------------------+------------+-------------------------+--------------------------------------------------+-----------------+-----------+
| 0  |   1   |     krishnanand      | 13-08-2005 |     krishna mansion     |      Krishna Mansion ,Krishnalaya,Shringeri      |      60000      |   120000  |
| 1  |   2   |        Akshay        | 14-08-2005 |       Akshayalaya       | Akshayalaya, Akshaya Dama,Yogendra Nagar,Shimoga |      35000      |   35000   |
| 2  |   3   |        sunil         | 21-10-2005 |      Sugamya Corner     |       sugamya corner ,Vijaya nagar,Mysore        |      50000      |   50000   |
| 3  |   4   |        Surya         | 10-11-2005 |    Suryodaya comforts   |          Suryodaya comforts,Srirampura           |      20000      |   20000   |
| 4  |   5   |        Aliya         | 15-11-2005 |  Kabule convention hall |                Nr Mohalla,Mysore                 |      20000      |   20000   |
| 5  |   6   | Chandan v            | 01-12-2005 |   Chinnaswammy stadium  |                    Bangalore                     |      12000      |   24000   |
| 6  |   7   |        Collin        | 25-12-2005 | Saint Philominas chruch |                      Mysore                      |      25000      |   50000   |
| 7  |   8   |       Yaradru        | 30-11-2005 |    Lalth Mahal Palace   |                      Mysore                      |      15000      |   30000   |
| 8  |   9   |        Akshay        | 14-08-2005 |       Akshayalaya       | Akshayalaya, Akshaya Dama,Yogendra Nagar,Shimoga |      35000      |   35000   |
| 9  |   10  |     krishnanand      | 13-08-2005 |     krishna mansion     |      Krishna Mansion ,Krishnalaya,Shringeri      |      60000      |   120000  |
| 10 |   11  |     krishnanand      | 16-08-2005 |     krishna mansion     |      Krishna Mansion ,Krishnalaya,Shringeri      |      60000      |   60000   |
+----+-------+----------------------+------------+-------------------------+--------------------------------------------------+-----------------+-----------+
 
 



Solution:

import pandas as pd
import numpy as np
from tabulate import tabulate

df = pd.read_csv('Event_Management_system.csv')

    
df = df.replace('', np.nan, regex=True)
df = df.dropna(axis = 1)
print(tabulate(df, headers ='keys', tablefmt = 'psql'))

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