Found 10476 Articles for Python

Python Pandas - Construct an IntervalArray from an array-like of tuples and return the left endpoints of each Interval

AmitDiwan
Updated on 13-Oct-2021 10:52:40

91 Views

To construct an IntervalArray from an array-like of tuples, use the pandas.arrays.IntervalArray.from_tuples() method. To return the left endpoints of each Interval in the IntervalArray, use the array.left property.At first, import the required libraries −import pandas as pdConstruct a new IntervalArray from an array-like of tuples −array = pd.arrays.IntervalArray.from_tuples([(10, 25), (15, 70)]) Display the intervals −print("Our IntervalArray...", array)Get the left endpoints −print("The left endpoints of each Interval in the IntervalArray as an Index...", array.left) ExampleFollowing is the code −import pandas as pd # Construct a new IntervalArray from an array-like of tuples array = pd.arrays.IntervalArray.from_tuples([(10, 25), (15, 70)]) # ... Read More

Python Pandas - Construct an IntervalArray from an array-like of tuples and return the right endpoints of each Interval

AmitDiwan
Updated on 13-Oct-2021 10:50:16

125 Views

To construct an IntervalArray from an array-like of tuples, use the pandas.arrays.IntervalArray.from_tuples() method. To return the right endpoints of each Interval in the IntervalArray, use the array.right property.At first, import the required libraries −import pandas as pdConstruct a new IntervalArray from an array-like of tuples −array = pd.arrays.IntervalArray.from_tuples([(10, 25), (15, 70)]) Display the intervals −print("Our IntervalArray...", array)Get the right endpoints −print("The right endpoints of each Interval in the IntervalArray as an Index...", array.right) ExampleFollowing is the code −import pandas as pd # Construct a new IntervalArray from an array-like of tuples array = pd.arrays.IntervalArray.from_tuples([(10, 25), (15, 70)]) # ... Read More

Python Pandas - Create a DataFrame from original index but enforce a new index

AmitDiwan
Updated on 13-Oct-2021 09:56:16

251 Views

To create a DataFrame from original index but enforce a new index, use the index.to_frame(). Set the parameter index to False.At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products')Display the Pandas indexprint("Pandas Index...", index) Enforce new index and convert index to DataFrame. Here, the actual index gets replaced by another index −print("Index to DataFrame...", index.to_frame(index=False))ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products') # Display the Pandas index print("Pandas Index...", index) # Return ... Read More

Python Pandas - Create a DataFrame with both the original index and name

AmitDiwan
Updated on 13-Oct-2021 09:54:02

170 Views

To create a DataFrame with both the original index and name, use the index.to_frame() method in Pandas.At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products')Display the Pandas index −print("Pandas Index...", index)Convert index to DataFrame −print("Index to DataFrame...", index.to_frame())ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products') # Display the Pandas index print("Pandas Index...", index) # Return the number of elements in the Index print("Number of elements in the index...", index.size) # Return ... Read More

Python Pandas - Create a Series with both the original index and name

AmitDiwan
Updated on 13-Oct-2021 09:48:54

183 Views

To create a Series with both the original index and name, use the index.to_series() method in Pandas. At first, import the required libraries -import pandas as pdCreating Pandas index:index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products')Convert index to series −print("Index to series...", index.to_series())ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products') # Display the Pandas index print("Pandas Index...", index) # Return the number of elements in the Index print("Number of elements in the index...", index.size) # Return the dtype of the data print("The ... Read More

Python Pandas - Return a list of the Index values

AmitDiwan
Updated on 13-Oct-2021 09:45:20

2K+ Views

To return a list of the Index values, use the index.to_list() method in Pandas. At first, import the required libraries -import pandas as pdCreating Pandas index −index = pd.Index([50.4, 10.2, 70.5, 110.5, 90.8, 50.6]) Display the Pandas index −print("Pandas Index...", index)Return a list −print("List of the index values...", index.to_list()) ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index([50.4, 10.2, 70.5, 110.5, 90.8, 50.6]) # Display the Pandas index print("Pandas Index...", index) # Return the number of elements in the Index print("Number of elements in the index...", index.size) # Return the ... Read More

Python Pandas - Create an Index with values cast to dtypes

AmitDiwan
Updated on 13-Oct-2021 09:41:27

312 Views

To create an Index with values cast to dtypes, use the index.astype() method in Pandas. At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index([50.4, 10.2, 70.5, 110.5, 90.8, 50.6]) Display the Pandas index −print("Pandas Index...", index)Convert datatype to int64 −index.astype('int64') ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index([50.4, 10.2, 70.5, 110.5, 90.8, 50.6]) # Display the Pandas index print("Pandas Index...", index) # Return the number of elements in the Index print("Number of elements in the index...", index.size) # Return the dtype of the ... Read More

Python - Show which entries in a Pandas Index are not NA

AmitDiwan
Updated on 13-Oct-2021 09:38:30

159 Views

To show which entries in a Pandas Index are not NA, use the index.notna() method. At first, import the required libraries -import pandas as pd import numpy as npCreating Pandas index with some NaN values −index = pd.Index([5, 65, np.nan, 17, 75, np.nan]) Display the Pandas index −print("Pandas Index...", index)Show which entries in a Pandas index are not-NA. Return True for non-NA entries −print("Check which entries are not-NA...", index.notna()) ExampleFollowing is the code −import pandas as pd import numpy as np # Creating Pandas index with some NaN values index = pd.Index([5, 65, np.nan, 17, 75, np.nan]) # ... Read More

Python - Show which entries in a Pandas Index are NA

AmitDiwan
Updated on 13-Oct-2021 09:32:24

122 Views

To show which entries in a Pandas Index are NA, use the index.isna() in Pandas. At first, import the required libraries -import pandas as pd import numpy as npCreating Pandas index with some NaN values −index = pd.Index([5, 65, np.nan, 17, 75, np.nan]) Display the Pandas index −print("Pandas Index...", index)Show which entries in a Pandas index are NA. Return True for NA entries −print("Check which entries are NA...", index.isna()) ExampleFollowing is the code −import pandas as pd import numpy as np # Creating Pandas index with some NaN values index = pd.Index([5, 65, np.nan, 17, 75, np.nan]) # ... Read More

Python Pandas - Drop the value when all levels are NaN in a Multi-index

AmitDiwan
Updated on 13-Oct-2021 09:30:35

947 Views

To drop the value when all levels are NaN in a Multi-index, use the multiIndex.dropna() method. Set the parameter how with value all.At first, import the required libraries -import pandas as pd import numpy as npCreate a multi-index with all NaN values. The names parameter sets the names for the levels in the index −multiIndex = pd.MultiIndex.from_arrays([[np.nan, np.nan], [np.nan, np.nan]], names=['a', 'b'])Drop the value when all levels iareNaN in a Multi-index. With all NaN values, the dropna() will drop all the values, if the "how" parameter of the dropna() is set "all" −print("Dropping the values when all levels are NaN...", ... Read More

Advertisements