I have the following dataframe: I tried with pivot table but I get the following error: any alternative to pivot table to do this? Answer You can use df = df.T to transpose the dataframe. This switches the dataframe round so that the rows become columns. You could also use pd.DataFrame.transpose().
Give column name when read csv file pandas
This is the example of my dataset. How to push down the first column and add the names column [TIME, X, Y, and Z] on the first column. The desired output is like this: Answer I’d do it like this:
How can I draw lines into numpy arrays?
I would like to be able to draw lines into numpy arrays to get off-line features for on-line handwriting recognition. This means I don’t need the image at all, but I need for some positions in a numpy array who an image of a given size would look like. I would like to be able to specify an image size
Extract sender’s email address from Outlook Exchange in Python using win32
I am trying to extract the sender’s email address from outlook 2013 using win32 package in python. There are two kinds of email address type in my Inbox, exchange and smtp. If I try to print the the sender’s email address of Exchange type, I am getting this: I have already gone through this link b…
Zsh: Conda/Pip installs command not found
So I installed Anaconda and everything is working. After I installed it I decided to switch to oh-my-zsh. I am now getting: when trying to use pip or conda installs 5.0.5 I have added to my zshenv.sh What is it that I’m missing? Answer It appears that my PATH is broken in my .zshrc file. Open it and add…
How to change the figure size of a seaborn axes or figure level plot
How do I change the size of my image so it’s suitable for printing? For example, I’d like to use to A4 paper, whose dimensions are 11.7 inches by 8.27 inches in landscape orientation. Answer You need to create the matplotlib Figure and Axes objects ahead of time, specifying how big the figure is:
How to get alternating colours in dashed line using matplotlib?
In matplotlib, I want to make a line using matplotlib.pyplot which is alternating black and yellow dashes, and then I want to include that line on the legend. How do I do that? I could do something like: but then the line on the legend would appear as a solid black line, rather than as black-and-yellow dashes…
Print ‘std err’ value from statsmodels OLS results
(Sorry to ask but http://statsmodels.sourceforge.net/ is currently down and I can’t access the docs) I’m doing a linear regression using statsmodels, basically: I know that I can print out the full set of results with: which outputs something like: I need a way to print out only the values of coef…
Scikit-learn train_test_split with indices
How do I get the original indices of the data when using train_test_split()? What I have is the following But this does not give the indices of the original data. One workaround is to add the indices to data (e.g. data = [(i, d) for i, d in enumerate(data)]) and then pass them inside train_test_split and then…
groupby weighted average and sum in pandas dataframe
I have a dataframe: I need a sum of adjusted_lots , price which is weighted average , of price and adjusted_lots , grouped by all the other columns , ie. grouped by (contract, month , year and buys) Similar solution on R was achieved by following code, using dplyr, however unable to do the same in pandas. is …