Tag: Pandas

Snippet 1 dfObj.iloc[: , [0, 2]] Similar Snippets Rename Row Pandas Code Example – pandas Index Max Pandas Code Example – pandas Add An Index Column Pandas Code Example – pandas Pandas Iterrows Code Example – pandas Slicing In Pandas Code Example – pandas Pandas Count Rows With Value Code Example – pandas Pandas Ttable… Continue reading Isolate Row Based On Index Pandas Code Example

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 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