Long-to-wide with missing data...any help?

More Marta Sandini's questions See All

Are there papers on?

I'm looking for a papers concerning either Christianity or neopagan religions and social media. What role does social media play in the spread of these religious movements? Any suggestions on the...

15 February 2021 655 4 View

Which commercial DNAse do you recommend me?

Which is the best DNAse (or DNAse kit) you have worked with? I am looking for a good DNAse that can remove DNA from an RNA sample in one pass. Material would be used for future RT-qPCR analysis....

18 November 2020 8,769 3 View

How to extract big peripheral membrane proteins?

I have been trying for a long time to see by Western Blot a 450 kDa-peripheral membrane protein from the Golgi apparatus with no success. I know that the electrophoresis and the membrane transfer...

28 September 2020 9,664 3 View

Maiden vs married name?

When I claimed authorship of papers written under my maiden name, they have now appeared under my married name, and I am worried this will cause confusion. How do I fix this issue?

12 August 2020 6,936 5 View

Rat DRG survival issue - how can I debug the protocol?

Hello everyone, I have been trying to establish primary rat DRG neuron culture for a couple of months already. I am using the protocol I found somewhere during the Google search, apparently...

14 June 2020 343 1 View

How to clean analytical size exclusion column?

Hello, We are using Superdex75 increase 3.2/30 GL size exclusion column in our lab and recently column pressure is to high to work on recommended flow rate 0.1 mL/min. I tried to clean the column...

19 May 2020 8,549 4 View

Unexpected problems running Photoquad software: How to fix the issue when it doesn't run anymore?

Hi, I've been using Photoquad software to analyze photoquadrats but suddenly the program doesn't run anymore and I am not able to solve the problem. I uninstalled both the MATLAB Compiler...

21 April 2020 4,707 1 View

Did any of you use polyethylene glycol to break down antibodies in Western Blot?

Hi, I've got a problem with my Western Blot. I have a low weight protein to detect but I suspect that my primary and secondary antibodies are clumping into a large ball at a higher molar mass than...

09 March 2020 2,856 3 View

Can anyone tell me the results of European Xenome research?

I know that the European Union has funded XENOME, an integrated project within the Sixth European Framework Programme (Life Sciences, Genomics and Biotechnology for Health), lasting 5 years...

18 November 2019 6,532 2 View

Hi all, is it possible to use XBridge BEH Amide Column to separate acetoin and 2,3-butanediol via HPLC?

Most of the methods that I have found recommend Aminex HPX-87H but I would rather avoind buying new column. Thanks, Marta

13 November 2019 6,221 2 View

How to compare two groups with only two measurements?

Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...

03 March 2021 8,796 3 View

Binary Logistic Generalized Linear Mixed model in SPSS. Is it doable?

I want to analyses the proportion of swimming sperm of three species of fish in two salinities. To analyse the proportion of swimming sperm in a Generalized Linear Model, I would use a Binary...

03 March 2021 2,297 3 View

Can we classify HV and LV lines based on line length?

I have dataset which shows the length of power lines. I need to classify the lines based on the line length. Is there a rule to classify the High voltage (HV) and low voltage (LV) lines based on...

03 March 2021 4,116 4 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

What test should i use in comparing the correlation between categorical and continuous variables?

Dear all, I have the variable (Surgery duration) represented by values in minutes and the variable (preoperative neuropraxia cases) represented as (Yes/No) values. I want to compare these two...

03 March 2021 5,427 5 View

Logistical regression using SPSS for a dichotomous dependent variable, with an independent variable of 1, 2, 5 and 10 seconds?

I have an experiment with 28 participants The independent variable is the times 1, 2, 5, and 10 used as the cross hairs during a task These 4 times were tested using 4 different blocks, each...

03 March 2021 9,692 2 View

How to increase a model accuracy ?

dear community, my model is based feature extraction from non stationary signals using discrete Wavelet Transform and then using statistical features then machine learning classifiers in order to...

03 March 2021 6,994 5 View

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature)?

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature-based reflection)? Thank you for your time and for...

03 March 2021 2,870 3 View

How to find the mean, SD and CI in SPSS?

Hi, I hope that someone can help me with this task: I have 5 groups of participants which are numbered in SPSS from 1 to 5 (according to their group number) and are all under the variable group....

03 March 2021 506 3 View

What degree of missing data in a particular case/participant results in Expectation-Maximisation no longer working?

I'm dealing with a mediation model and am using the PROCESS module in SPSS. Due to SPSS and PROCESS being limited in the imputation methods - being unable to handle multiple imputation - the other...

02 March 2021 4,362 1 View

Moreno S. Rodrigues

Hi Marta Sandini you could use the function spread present on R tidyverse package. There are a explanation about how to use it in this book https://r4ds.had.co.nz/tidy-data.html

Marta Sandini

Thank you!! Moreno S. Rodrigues :) will try and let you know!

Jos Feys

Indeed you could use the spead function, as indicated by Moreno S. Rodrigues. In attachment an R script as an example.

You can run R scripts for free online:

https://rdrr.io/snippets/