The pandas equivalent to...
select * from table where column_name = some_value
is:
table[table.column_name == some_value]
Multiple conditions:
{"results":[{"date":"08/06/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"5-SIG 19-5117","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/138645.pdf","categories":"","motionedBy":"","sdSummary":"5-SIG 19-5117. Microsoft Word - Document1. Five-signature letter pending","transcript":"","tsURL":"","tsSummary":""},{"date":"08/06/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"CEO Memo 19-5117a","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/138613.pdf","categories":"","motionedBy":"","sdSummary":"CEO Memo 19-5117a. County of Los Angeles CHIEF EXECUTIVE OFFICE Kenneth Hahn Hall of Administration 500 West Temple Street, Room 713, Los Angeles, California 90012 (213) 974-1101 http://ceo.lacounty.gov Board of Supervisors HILDA L. SOLIS Augus","transcript":"","tsURL":"","tsSummary":""},{"date":"08/06/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"CEO Memo 19-5135a","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/138611.pdf","categories":"","motionedBy":"","sdSummary":"CEO Memo 19-5 |
{"results":[{"date":"07/23/2019","sop":"Statement of Proceedings for 7/23/19","sopURL":"http://file.lacounty.gov/SDSInter/bos/sop/1059442_072319.pdf","sopSummary":"Statement of Proceedings for 7/23/19. Statement Of Proceedings. STATEMENT OF PROCEEDINGS FOR THE REGULAR MEETING OF THE BOARD OF SUPERVISORS OF THE COUNTY OF LOS ANGELES HELD IN ROOM 381B OF THE KENNETH HAHN HALL OF ADMINISTRATION 500 WEST TEMPLE","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"","tsURL":"","tsSummary":""},{"date":"07/16/2019","sop":"Statement of Proceedings for 7/16/19","sopURL":"http://file.lacounty.gov/SDSInter/bos/sop/1058736_071619.pdf","sopSummary":"Statement of Proceedings for 7/16/19. Statement Of Proceedings. STATEMENT OF PROCEEDINGS FOR THE REGULAR MEETING OF THE BOARD OF SUPERVISORS OF THE COUNTY OF LOS ANGELES HELD IN ROOM 381B OF THE KENNETH HAHN HALL OF ADMINISTRATION 500 WEST TEMPLE","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"","tsURL":"","t |
{"results":[{"date":"11/05/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"11-05-19 Board Meeting Transcript","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1064146_110519.pdf","tsSummary":"11-05-19 Board Meeting Transcript. November 5, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat Reader"},{"date":"10/29/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"10-29-19 Board Meeting Transcript (C)","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1063943_102919.pdf","tsSummary":"10-29-19 Board Meeting Transcript (C). October 29, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat R"},{"date":"10/22/2019","sop":"","sopURL":"","sopSumma |
{"results":[{"date":"07/30/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"07-30-19 Board Meeting Transcript (C)","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1059255_073019.pdf","tsSummary":"07-30-19 Board Meeting Transcript (C). July 30, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat R"},{"date":"07/23/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"07-23-19 Board Meeting Transcript (C)","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1058916_072319.pdf","tsSummary":"07-23-19 Board Meeting Transcript (C). July 23, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat R"},{"date":"07/16/2019","sop":"","sopURL":"","sopSummary" |
{"results":[{"date":"11/19/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"HLS Motion 19-7360","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/141895.pdf","categories":"","motionedBy":"1 - Solis","sdSummary":"HLS Motion 19-7360. Motion_2004. MOTION SOLIS ___________________________ RIDLEY-THOMAS ___________________________ KUEHL ___________________________ BARGER ___________________________ HAHN ___________________________ AGN","transcript":"","tsURL":"","tsSummary":""},{"date":"11/19/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"HLS Motion 19-7361","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/141891.pdf","categories":"","motionedBy":"1 - Solis","sdSummary":"HLS Motion 19-7361. Motion_2004. MOTION SOLIS ___________________________ RIDLEY-THOMAS ___________________________ KUEHL ___________________________ BARGER ___________________________ HAHN ___________________________ AGN","transcript":"","tsURL":"","tsSummary":""},{"date":"11/19/2019","sop":"","sopURL":"","sopSummary":"","sup |
The pandas equivalent to...
select * from table where column_name = some_value
is:
table[table.column_name == some_value]
Multiple conditions:
place | palm | other | |
---|---|---|---|
Redondo Beach | 2972 | 10637 | |
Santa Monica | 6802 | 28433 | |
Beverly Hills | 4641 | 22314 | |
Artesia | 500 | 2450 | |
South Pasadena | 1555 | 9794 | |
Culver City | 2249 | 14737 | |
West Hollywood | 1082 | 7984 | |
Long Beach | 16605 | 124217 | |
Pasadena | 8133 | 62999 |