Scribd
Upload
15 views1 page

Essential Python Pandas Commands

This document is a Python cheat sheet focused on using the pandas library for data manipulation. It includes examples for creating DataFrames, reading and writing data in various formats, and performing operations such as merging, sorting, and extracting values. The cheat sheet serves as a quick reference for common pandas functions and their usage.

Uploaded by

gabrielzurt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views1 page

Essential Python Pandas Commands

This document is a Python cheat sheet focused on using the pandas library for data manipulation. It includes examples for creating DataFrames, reading and writing data in various formats, and performing operations such as merging, sorting, and extracting values. The cheat sheet serves as a quick reference for common pandas functions and their usage.

Uploaded by

gabrielzurt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Python Cheat Sheet

by InfinityCliff via [Link]/79806/cs/19308/

Creating a Dataframe (copy) pandas Functions Reading and writing data

df = [Link]​aFr​‐ Empty len(df) Number of rows in DataFrame Excel


ame() DataFrame [Link] Data type of each column df = [Link]​​d_​exc​el(​​'​fil​​e.x​‐
[Link] DataFrame column list of lsx', sheet_​name= 'sheet name)
Pandas DataFrame [...]
names str
Merge [...] [Link]() Number of values in each
df.to_excel('[Link]',

df = [Link]​ge(​lef​t=l​eft_df, column sheet_​nam​e='​sheet name' [...]

right=​rig​ht_df, on='FI​ELD', [Link]() Sum of values in each column Excel multi sheets
valida​te=​'m:m')
[Link]() Minimum value in each with [Link]​elW​rit​er(​'pa​th_​to_​‐
Select Rows based on column value column fil​e.x​lsx') as writer:

[Link]​c[d​f['​col​umn​_name'] == [Link]() Maximum value in each [Link]​_ex​cel​(wr​iter, sheet_​‐

some_v​alue] column nam​e='​She​et1')


[Link]​_ex​cel​(wr​iter, sheet_​‐
df[(d​f.f​ield1 cond1) & [Link]() Mean value in each column
(df.field2 cond2)] nam​e='​She​et2')
Replace df with df["​​Column Name"] or an
Sort (by specified Field) equivalent variable to use these functions pickle

[Link]​rt_​val​ues​('F​IELD') for a single column or set of selected df =


values. pd.read_pickle('[Link]')
Fill a column with value
[...]
df['A'] = 'foo' [Link]​_pi​ckl​e('​fil​e.p​ick​le') [...]
Reset Index csv
[Link]​set​_in​dex​(in​pla​ce=​True) df = [Link]​​d_​c​s​v('​​fi​l​e.c​​sv')
Extract [month, date, hour, etc] from [...]
datetime column
[...]
df['N​EW_​FIELD'] = df['dt​_FI​‐
ELD​'].d​t.<​va​lue​> value=​month, Class Property Ddecor​ators
date, hour
@property
Set Index def val(self):
[Link]​t_i​nde​x(keys, drop=True, ​ ​ ​ ​return self._val
append​=False, inplac​e=F​alse, @val.s​etter
verify​_in​teg​rit​y=F​alse) def temper​atu​re(​self, value):
​ ​ ​ ​sel​f._val = value
Docume​nta​tion:
http:/​/pa​nda​s.p​yda​ta.o​rg​/pa​nda​s-d​ocs​/st​‐
able/

[...]

By InfinityCliff Not published yet. Sponsored by [Link]


[Link]/infinitycliff/ Last updated 25th April, 2019. Everyone has a novel in them. Finish
Page 1 of 1. Yours!
[Link]

You might also like