how to use values of a pandas DataFrame as numpy array index
Sounak
I have a pandas dataFrame like this.
The X, Y, Z are they (x,y,z) coordinates that represent a point inside a cube of side-length 255.
I want to create a numpy array/dataFrame from this, whose index will be the (x,y,z) coordinates and value is the intensity.
the output should be
data[133,55,250] = 8
data[133,61,254] = 21
...
I tried something like this
data = np.zeros((255,255,255), dtype=np.int)
index = np.array((temp['X'], temp['Y'], temp['Z']))
but returned index is a (3,15) array.
I want a index where
data[index] = intensity
will give me my result.
I am kind of lost. Some help will be appreciated.
Thanks.
unutbu
Instead of
index = np.array((temp['X'], temp['Y'], temp['Z']))
you could use integer array indexing to perform the assignment:
data = np.zeros((256, 256, 256), dtype=np.int)
data[temp['X'], temp['Y'], temp['Z']] = temp['intensity']
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How to apply different rules for different start_urls in python scrapy?
- Next: Angular UI state in combination with service
Related
Related Related
- 1
how to use values of a pandas DataFrame as numpy array index
- 2
What index should I use to convert a numpy array into a pandas dataframe?
- 3
Use pandas dataframe apply to replace row values from a numpy array
- 4
Use index values as category values in pandas dataframe
- 5
How to efficiently iterate a pandas DataFrame and increment a NumPy array on these values?
- 6
How to add '$' to my pandas dataframe values and use a column as index?
- 7
Accessing Pandas dataframe values when index values contained in separate numpy array
- 8
Create Pandas dataframe from numpy array and use first column of the array as index
- 9
replacing pandas dataframe variable values with a numpy array
- 10
Modify pandas dataframe values with numpy array
- 11
numpy array converted to pandas dataframe drops values
- 12
How to exchange the role of values and index in pandas DataFrame?
- 13
How to set index values in a MultiIndex pandas DataFrame?
- 14
Creating a Pandas DataFrame from a Numpy array: How do I specify the index column and column headers?
- 15
how to multiply pandas dataframe with numpy array with broadcasting
- 16
Convert Pandas Dataframe Date Index and Column to Numpy Array
- 17
How do you use pandas.DataFrame columns as index, columns, and values?
- 18
Replace values in numpy 2D array based on pandas dataframe
- 19
how to use lists as values in pandas dataframe?
- 20
Pandas dataframe indexing: Use of '.values' for different index occurrence frequencies
- 21
How to use sklearn fit_transform with pandas and return dataframe instead of numpy array?
- 22
Pandas Divide dataframe by index values
- 23
How to find boolean values of a column of numpy arrays in a pandas Dataframe?
- 24
How to get sum of values grouped by the pandas DataFrame and make numpy matrix?
- 25
How to create a column depending on the row index values in a multiindex pandas dataframe?
- 26
How to create a column depending on the row index values in a multiindex pandas dataframe?
- 27
How do I convert a pandas Series or index to a Numpy array?
- 28
Pandas DataFrame to Numpy Array ValueError
- 29
Pandas DataFrame to multidimensional NumPy Array
Comments