This is a beginner question. I want to split a pandas df horizontally all n entries and then insert the split data each as a separate column. E.g. n=2: a b to a b c d e f 1 11 1 3 5 11 13 15 2 12 2 4 6 12 14 16 3… Read More Horizontal split of Pandas DataFrame to append the content as a column via Numpy

I want to expand/repeat each element in a 1D array for different times x = array([7,1,9]) #1d array rep_size = array([3,2,2]) # repeat number for each element in x result = arary([7,7,7,1,1,9,9]) #expected result Is there a numpy function can do this if I don’t want to use a for loop. Thanks. >Solution : Use… Read More expand 1d numpy array

I have dataframe that looks like the following: Given Y1 eY1 Y2 eY2 Y3 eY3 Y4 eY4 Y5 0 0.45 0.25 0.3550 0.39 0.4200 0.43 0.5950 0.65 0.7175 0.74 1 0.39 0.15 0.2400 0.27 0.5025 0.58 0.7675 0.83 0.8600 0.87 2 0.99 0.30 0.4875 0.55 0.7225 0.78 0.9075 0.95 0.9800 0.99 3 0.58 0.23 0.2825… Read More Matching value to column index pandas

This is the problem I am trying to solve: Write a function my_is_orthogonal(v1,v2, tol), where v1 and v2 are column vectors of the same size and tol is a scalar value strictly larger than 0. The output should be 1 if the angle between v1 and v2 is within tol of π/2; that is, |π/2−θ… Read More I need Assistance with my Function Problem, I am getting zero for all my answers

I wish to construct a data frame from the data I’m showcasing here. Can anyone help me in the right direction? Thanks a lot in advance!! test_comment = "We’re exceptionally proud of the 62,000 employees who work in our restaurants, along with the hundreds of Russian suppliers who support our business, and our local franchisees.… Read More Construct a data frame with pandas

I am trying to do the following: Supposing I have the following column on pandas, where there will be always two values that are equal in sequence. l = [np.nan, np.nan, 10, np.nan, np.nan, np.nan, 10, np.nan, 4, np.nan, 4, 5, np.nan, 5, np.nan, 2, np.nan, 2, 1, 1] How can I fill NaN values… Read More Pandas foward fill in between – same values

I have the following dataframe: df1=[[1,1,2,2],[3,3,4,4]] df1 = pd.DataFrame(df1) 0 1 2 3 0 1 1 2 2 1 3 3 4 4 I want to reconstruct this dataframe so it looks like the following: df=[[1,1],[2,2],[3,3],[4,4]] df = pd.DataFrame(df) 0 1 0 1 1 1 2 2 2 3 3 3 4 4 There must… Read More Reconstruct columns by alternatively putting the values in column -> pandas

I am studying Fourier series and want to plot some of the results in Python. One common function to analyze using Fourier series is the hat function: The code below shows two different ways that I’ve coded the hat function. One uses numpy, the other uses a custom function hat(x,a,L) that I wrote. The parameter… Read More Is there a better way to define this simple hat function?

I come across this issue often, and I would be surprised if there wasn’t some very simple and pythonic one-liner solution to it. Suppose I have a method or a function that takes a list or some other iterable object as an argument. I want for an operation to be performed once for each item… Read More What is the pythonic way of "iterating" over a single item?

I have 2 arrays; one is small array and second is big array as follows, import pandas as pd import numpy as np dat1 = np.array([2, 3 ,4 ,4 ,3 ,2, 2, 4 ,3 ,4 ,4, 3]) dat2 = np.array([1, 4 ,4, 4, 2 ,1, 3 ,3 ,2, 3, 3, 1]) small_array = pd.crosstab(dat1, dat2)… Read More Place a small array into a big array