I have one dataframe with classes and two components and a second one with elements and the same components. df1: df1 = pd.DataFrame({‘Class’:[‘banana’, ‘apple’], ‘comp1’:[1, 2], ‘comp2’:[-5, 4]}) df2: df2 = pd.DataFrame({‘Element’:[‘K’, ‘Mg’], ‘comp1’:[3, -4], ‘comp2’:[1, 3]}) I want to multiply them row by row in a way that would generate the following output: output… Read More Row by row multiplication on pandas or numpy

i have a DataFrame a= pd.read_csv(‘period_table’,index_col=0) df = pd.DataFrame(a) i want to add at my var Me only the integer value of a row and i do in this way Me = pd.Series(df.loc[s[0],’ipo_oso’:’neg’]) Me=Me.dropna() Me = [int(x) for x in np.array(Me)] where df is my DataFrame, s[0] is an external variable like ‘H’. i have… Read More write more efficently numpy and pandas code

I was doing some onehotencoding and when I tried to merge the arrays with np.hstack, I got this error. As of my knowledge hstack has not been depreceated nor they are planning to do so. Also everything is correct with the code(in my opinion), cause it ran just few hours back perfectly. Is there any… Read More module 'numpy' has no attribute 'hstacK'

I have an array A. I want to print total number of values in the range [1e-11,1e-7]. But I am getting an error. I present the expected output. import numpy as np A=np.array([ 4.21922009e+002, 4.02356746e+002, 3.96553289e-09, 3.91811967e-010, 3.88467908e-08, 3.86636300e-010]) B=1e-11<A<1e-07 print(B) The error is in <module> B=1e-11<A<1e-07 ValueError: The truth value of an array with… Read More Number of values within a certain range in Python

I have been stuck on this problem for hours. Let’s say we have a 1D array of floats: [0.12345678, 0.23456788, 0.23456789] I just need to find the max value of the array and it’s index. I know I can do that with np.max and np.argmax. res = np.max(array) index = np.argmax(array) In this case, the… Read More Numpy – Determine nearly equivalent floats before finding max value and index in 1D array

I am new to Python and even more so to NumPy and I couldnt find a solution for this for now. I have a Numpy array a = [1 4 6] and another b that consists of 3 rows and 3 cols full of zeros [[0 0 0] [0 0 0] [0 0 0]] How… Read More How to assign a value to certain indices of a Numpy array when the indices are given in another numpy array?

I have the following column in a data-frame (it is an example): First row is: ‘{"100":10,"50":3,"-90":2}’. Second row is: ‘{"100":70,"50":3,"-90":2,"-40":3}’. I want to calculate a weighted average where the dictionary’s keys are the values and the dictionary’s values are the weights of the weighted average. The final value of the first row should be: 64.666,… Read More Weighted average of a dictionary – Pandas

I would like to sum from list of list as below array([[[1, 1, 1], [2, 2, 2], [3, 3, 3], [4, 4, 4], [5, 5, 5]], [[1, 1, 1], [2, 2, 2], [3, 3, 3], [4, 4, 4], [5, 5, 5]], [[1, 1, 1], [2, 2, 2], [3, 3, 3], [4, 4, 4], [5, 5,… Read More How to sum second list from list of list in Python

I have a pandas dataframe df :- ID COST 1F 2F 3F 4G 1 362 0 1 1 1 2 269 0 1 0 0 3 346 1 1 1 1 4 342 0 0 0 0 I have a total_cost dictionary : total_cost ={‘1F’ : 0.047,’2F’ : 0.03,’3F’: 0.023,’4G’: 0.025} I want to add… Read More Pandas map values from Dictionary efficiently

I’m new to Python and Stackoverflow, so I’m sorry in advance if this question is silly and/or duplicated. I’m trying to write a code that replaces every nth 0 in the numpy array that consists of 0 and 1. For example, if I want to replace every third 0 with 0.5, the expected result is:… Read More How to replace every third 0 in the numpy array consists of 0 and 1?