Tag: Pandas

How To Change Column Name In Pandas Code Example

Snippet 1 df = df.rename(columns = {‘myvar’:’myvar_new’}) Snippet 2 df.rename(columns={‘oldName1’: ‘newName1’, ‘oldName2’: ‘newName2′}, inplace=True, errors=’raise’) # Make sure you set inplace to True if you want the change # to be applied to the dataframe Snippet 3 df.rename(columns={“old_col1”: “new_col1”, “old_col2”: “new_col2”}) Snippet 4 print(df.rename(columns={‘A’: ‘a’, ‘C’: ‘c’})) # a B c # ONE 11 12… Continue reading How To Change Column Name In Pandas Code Example

Command To Read File In Python Using Pandas Code Example

Snippet 1 import panda as pd file_csv = pd.read_csv(“file path”) ## as csv format file_excel = pd.read_excel(“file path”) ## as excel format file_json = pd.read_json(“file path”) ## as json format file_html = pd.read_html(“file path”) ## as html format file_localClipboard = pd.read_clipboard(“file path”) ## as clipboard format file_MSExcel = pd.read_excel(“file path”) ## as excel format file_HDF5… Continue reading Command To Read File In Python Using Pandas Code Example

How To Change The Column Order In Pandas Dataframe Code Example

Snippet 1 df = df.reindex(columns=column_names) Snippet 2 # setting up a dummy dataframe raw_data = {‘name’: [‘Willard Morris’, ‘Al Jennings’, ‘Omar Mullins’, ‘Spencer McDaniel’], ‘age’: [20, 19, 22, 21], ‘favorite_color’: [‘blue’, ‘red’, ‘yellow’, “green”], ‘grade’: [88, 92, 95, 70]} df = pd.DataFrame(raw_data, index = [‘Willard Morris’, ‘Al Jennings’, ‘Omar Mullins’, ‘Spencer McDaniel’]) df #now ‘age’… Continue reading How To Change The Column Order In Pandas Dataframe Code Example

Concatenate Dataframes Pandas Code Example

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    

How To Drop Columns In Pandas Code Example

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

Convert Pandas Data Frame To Latex File 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

How To Get Dummies In A Dataframe Pandas 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

Create Additional Rows For Missing Dates 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