Tag: Pandas

Snippet 1 df_col = pd.concat([df1,df2], axis=1) df_col Snippet 2 df[“period”] = df[“Year”] + df[“quarter”] Snippet 3 # Pandas for Python df[‘col1 & col2’] = df[‘col1’]+df[‘col2’] #Output #col1 col2 col1 & col2 #A1 A2 A1A2 #B1 B2 B1B2 Copyright © Code Fetcher 2020    

Snippet 1 # Let df be a dataframe # Let new_df be a dataframe after dropping a column new_df = df.drop(labels=’column_name’, axis=1) # Or if you don’t want to change the name of the dataframe df = df.drop(labels=’column_name’, axis=1) # Or to remove several columns df = df.drop([‘list_of_column_names’], axis=1) # axis=0 for ‘rows’ and axis=1… Continue reading How To Drop Columns In Pandas Code Example

Snippet 1 # import DataFrame import pandas as pd    # using DataFrame.to_latex() method gfg = pd.DataFrame({‘Name’: [‘Marks’, ‘Gender’],                     ‘Jitender’: [’78’, ‘Male’],                      ‘Purnima’: [‘78.9’, ‘Female’]})    print(gfg.to_latex(index = False, multirow = True)) Snippet 2 with open(‘mytable.tex’, ‘w’) as tf: tf.write(df.to_latex()) Snippet 3 import pandas as pd df = pd.DataFrame({“a”:range(10), “b”:range(10,20)}) with open(“my_table.tex”, “w”) as f:… Continue reading Convert Pandas Data Frame To Latex File Code Example

Snippet 1 note: dummies = pd.get_dummies(df[[‘column_1’]], drop_first=True) note:for more that one coloum keep ading in the list dummies = pd.get_dummies(df[[‘column_1’, ‘column_2′,’column_3’]], drop_first=True) Snippet 2 >>> s = pd.Series(list(‘abca’)) >>> pd.get_dummies(s) a b c 0 1 0 0 1 0 1 0 2 0 0 1 3 1 0 0 Snippet 3 df = pd.get_dummies(df, columns=[‘type’])… Continue reading How To Get Dummies In A Dataframe Pandas Code Example

Snippet 1 In [11]: idx = pd.period_range(min(df.date), max(df.date)) …: results.reindex(idx, fill_value=0) …: Out[11]: f1 f2 f3 f4 2000-01-01 2.049157 1.962635 2.756154 2.224751 2000-01-02 2.675899 2.587217 1.540823 1.606150 2000-01-03 0.000000 0.000000 0.000000 0.000000 2000-01-04 0.000000 0.000000 0.000000 0.000000 2000-01-05 0.000000 0.000000 0.000000 0.000000 2000-01-06 0.000000 0.000000 0.000000 0.000000 2000-01-07 0.000000 0.000000 0.000000 0.000000 2000-01-08 0.000000 0.000000… Continue reading Create Additional Rows For Missing Dates Pandas Code Example

Snippet 1 df = dataframe.groupby([‘date’, ‘sitename’, ‘name’]).sum() Copyright © Code Fetcher 2020    

Snippet 1 import numpy as np import pandas as pd df = pd.DataFrame(np.random.randint(0,100,size=(100, 4)), columns=list(‘ABCD’)) Copyright © Code Fetcher 2020    

Snippet 1 >>> d = {‘col1’: [1, 2], ‘col2’: [3, 4]} >>> df = pd.DataFrame(data=d) >>> df col1 col2 0 1 3 1 2 4 Snippet 2 >>> df2 = pd.DataFrame(np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]]), … columns=[‘a’, ‘b’, ‘c’]) >>> df2 a b c 0 1 2 3 1 4 5… Continue reading Creating A Pandas Df Code Example

Snippet 1 df.drop(columns=[‘B’, ‘C’]) Snippet 2 df.drop([‘feature_1’,’feature_2’], inplace = True, axis = 1) Snippet 3 df = df.drop([‘B’, ‘C’], axis=1) Snippet 4 df = pd.DataFrame(np.arange(12).reshape(3, 4), … columns=[‘A’, ‘B’, ‘C’, ‘D’]) >>> df A B C D 0 0 1 2 3 1 4 5 6 7 2 8 9 10 11 Drop columns df.drop([‘B’,… Continue reading Delete Columns Pandas Code Example

Snippet 1 pd.DataFrame.from_dict(df, orient=’index’).transpose() #A pd.DataFrame(dict([ (k,pd.Series(v)) for k,v in df.items() ])) #B (Better) Copyright © Code Fetcher 2020    

Snippet 1 note: df is your dataframe df = df.drop(‘coloum_name’,axis=1) Snippet 2 >>>df = pd.DataFrame(np.arange(12).reshape(3, 4), columns=[‘A’, ‘B’, ‘C’, ‘D’]) >>>df A B C D 0 0 1 2 3 1 4 5 6 7 2 8 9 10 11 >>> df.drop([‘B’, ‘C’], axis=1) A D 0 0 3 1 4 7 2 8 11… Continue reading Drop A Column In Pandas Code Example