python - Assigning multiple pandas columns using list slice -


in python, possible assign multiple variables objects in list. possible same pandas dataframe example:

df.trinucleotide 0   aca  1   acc 2   acg 3   act 4   aca 5   acc 6   acg 7   act 8   aca 9   acc  df.loc[:,['first','second','third']] =  df.trinucleotide.apply(lambda x: list(x))

this results in keyerror: "['first' 'second' 'third'] not in index" error while separating variables commas not work well. 

df.loc[:,'first'], df.loc[:,'second'],df.loc[:,'third'] =  df.trinucleotide.apply(lambda x: list(x))  valueerror: many values unpack

is there way without explicitly assigning each variable slice index of list?

to create multiple columns when using apply, think it's best return series rather list. can set column names setting them index series. can do:

# reading data in df = pd.read_clipboard(header=none, index_col=0) df.columns = ['trinucleotide'] df out[9]:    trinucleotide 0               0           aca 1           acc 2           acg # etc.  new_cols = df['trinucleotide'].apply(     lambda x: pd.series(list(x), index=['first', 'second', 'third']) ) df[['first', 'second', 'third']] = new_cols  df out[8]:    trinucleotide first second third 0                                  0           aca          c     1           acc          c     c 2           acg          c     g 3           act          c     t 4           aca          c     5           acc          c     c 6           acg          c     g 7           act          c     t 8           aca          c     9           acc          c     c

Comments

Post a Comment

Popular posts from this blog

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more