Tag: Pandas

Snippet 1 print(df.columns) Copyright © Code Fetcher 2020    

Snippet 1 df[“C”] = df[[“A”, “B”]].max(axis=1) Snippet 2 max_value_column = df[“column_name”].max() Copyright © Code Fetcher 2020    

Snippet 1 The Pandas module is used for working with tabular data. It allows us to work with data in table form, such as in CSV or SQL database formats. We can also create tables of our own, and edit or add columns or rows to tables(DATAFRAMES AND SERIES) The Numpy module is mainly used… Continue reading Numpy Vs Pandas Code Example

Snippet 1 from sklearn.preprocessing import MultiLabelBinarizer mlb = MultiLabelBinarizer() df = df.join(pd.DataFrame(mlb.fit_transform(df.pop(‘Col3’)), columns=mlb.classes_, index=df.index)) Similar Snippets Onehot Encode List Of Columns Pandas Code Example – pandas How To Drop Columns In Pandas Code Example – pandas Pandas Select All Columns Except One Code Example – pandas Pandas Merge Two Columns From Different Dataframes Code Example… Continue reading Onehot Encode List Of Columns Pandas Code Example

Snippet 1 y = pd.get_dummies(df.Countries, prefix=’Country’) print(y.head()) # from here you can merge it onto your main DF Snippet 2 from sklearn.preprocessing import MultiLabelBinarizer mlb = MultiLabelBinarizer() df = df.join(pd.DataFrame(mlb.fit_transform(df.pop(‘Col3’)), columns=mlb.classes_, index=df.index)) Copyright © Code Fetcher 2020    

Snippet 1 >>> df.sort_values(by=[‘col1′]) col1 col2 col3 0 A 2 0 1 A 1 1 2 B 9 9 5 C 4 3 4 D 7 2 3 NaN 8 4 Snippet 2 df.sort_values(by=’col1’, ascending=False) Snippet 3 sorted = df.sort_values(‘column-to-sort-on’, ascending=False) #or df.sort_values(‘name’, inplace=True) Copyright © Code Fetcher 2020    

Snippet 1 def EOQ(D,p,ck,ch): Q = math.sqrt((2*D*ck)/(ch*p)) return Q ch=0.2 ck=5 df[‘Q’] = df.apply(lambda row: EOQ(row[‘D’], row[‘p’], ck, ch), axis=1) df Snippet 2 df[‘a’] = df[‘a’].apply(lambda x: x + 1) Copyright © Code Fetcher 2020    

Snippet 1 # Returns the cartesian product with another DataFrame df.select(“age”, “name”).collect() # [Row(age=2, name=’Alice’), Row(age=5, name=’Bob’)] df2.select(“name”, “height”).collect() # [Row(name=’Tom’, height=80), Row(name=’Bob’, height=85)] df.crossJoin(df2.select(“height”)).select( “age”, “name”, “height”).collect() # [Row(age=2, name=’Alice’, height=80), Row(age=2, name=’Alice’, height=85), Row(age=55, name=’Bob’, height=80), Row(age=5, name=’Bob’, height=85)] Snippet 2 a = [1, 2, 3] b = [“a”, “b”, “c”] index =… Continue reading Pandas Cartesian Product Code Example

Snippet 1 DataFrame[“new_column”] = DataFrame[“column1”] + DataFrame[“column2”] Copyright © Code Fetcher 2020    

Snippet 1 for y in agg.columns: if(agg[y].dtype == np.float64 or agg[y].dtype == np.int64): treat_numeric(agg[y]) else: treat_str(agg[y]) Copyright © Code Fetcher 2020    

Snippet 1 import pandas as pd data = pd.DataFrame({‘A’ : [1, 2, 3, 4], ‘B’ : [1,2,3,4]}) def test(data): data = data + 1 return data data = test(data) Snippet 2 import pandas as pd data = pd.DataFrame({‘A’ : [1, 2, 3, 4], ‘B’ : [1,2,3,4]}) def test(): global data data = data + 1… Continue reading How To Set Pandas Dataframe As Global Code Example