Python n00b, here. I work with event data in csv files. I am writing a script that reorders columns and sorts by time. This part of the script works, but I want to filter out specific rows based on the value of a single column:
Description Date Start End Location Organization
Meeting 2/14/14 9:00 9:30 Conference Room Org1
Meeting 2/14/14 9:30 10:00 Conference Room Org2
If I don't want Org1, how can I filter the rows for these group meetings.
I am using pandas:
import pandas as pd
df = pd.read_csv('day_of_the_week.csv')
df = df.sort('MEETING START TIME')
location = df.LOCATION
date = df.DATE
starttime = df['MEETING START TIME']
endtime = df['MEETING END TIME']
description = df.DESCRIPTION
organization = df.ORGANIZATION
df.to_csv('Full_List_sorted.csv', cols=["DATE","MEETING START TIME","MEETING END TIME","DESCRIPTION","ORGANIZATION","LOCATION"],index=False)
thank
source
share