python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - analysis

Python pandas convert csv file into wide long txt file and put the values that have the same name in the "MA" column in the same row

I want to get a file from the csv file formatted as follows: CSV file: Desired output txt file (Header italicized): MA Am1 Am2 Am3 Am4 MX1 X Y - - MX2 9 1...
test-img

grapefruiticecoffee

python

pandas

csv

file

analysis

Votes: 0

Answers: 1

Latest Answer

You can try this. Based on unique MA value groups, get the values [names column here] Create a new dataframe with it. Expand the values list to columns and add it to new dataframe. Copy name column f...
test-img

Manjunath K Mayya

How can I move subsets of rows to new rows in R?

I created a survey where respondents are asked questions about a number of other people. The resulting dataset has the following variables: respondent ID Number of people you have information on (1-...
test-img

Vinnie De Craim

r

dataframe

rows

analysis

Votes: 0

Answers: 1

Latest Answer

What you are looking for is to convert your data from a so-called "wide" format to a "long(er)" format. There is a handy function for this: pivot_longer() (see here for more detail...
test-img

mat

R: I do not get P-Values for rmANOVA using aov()

I have tried to perform a two-way repeated-measures analysis, but I cannot get the p-values with my R code. Do you have any ideas about what is wrong? myData.mean <- aggregate(main$ER, ...
test-img

Paul B&#228;umer

r

statistics

data-science

analysis

Votes: 0

Answers: 2

Latest Answer

It is not clear to me why you aggregate your data into means before doing the ANOVA, as an ANOVA is done on the raw data. This may very well be the reason why you do not get any p-values (and your res...
test-img

b_siepe

Cleaning up tweets before sentiment analysis on cryptocurrencies

I am trying to analyse twitter sentiment and right now I have a code which scrapes tweets from twitter with API and puts them in an excel file followed by their sentiment score, however I want to try ...
test-img

Bram Vanzon

python

twitter

analysis

cryptocurrency

Votes: 0

Answers: 1

Latest Answer

Suppose you have the following function to clean tweets (this is just your function with indentation fixed): def clean_tweet(tweet): if type(tweet) == np.float: return "" tem...
test-img

Elijah Cox

Posts

Questions

Blogs

Jobs