python - how to add new item in pandas series without erasing other items -

-

i have following pandas series. 

new_orders_list out[853]:  cluster 1    [525, 526, 533] cluster 2    [527, 528, 532] cluster 3    [519, 534, 535] cluster 4              [530] cluster 5         [529, 531] cluster 6    [520, 521, 524]

and,i have 2 more series after slicing on dataframe.

condition out[854]:  5    525 name: order_id, dtype: object  condition2 out[855]:  clusters cluster 6    1 name: quant_bought, dtype: int64

now want add value of condition series 525 new_orders_list @ cluster 6 (index condition2 series) location. , erasing off 525 cluster 1 location. so, should this

cluster 1    [526, 533] cluster 2    [527, 528, 532] cluster 3    [519, 534, 535] cluster 4              [530] cluster 5         [529, 531] cluster 6    [520, 521, 524, 525]

i doing following in python. appends stored values.

new_orders_list.append(pd.series(condition.values ,index =  condition2.index))  cluster 1    [525, 526, 533] cluster 2    [527, 528, 532] cluster 3    [519, 534, 535] cluster 4              [530] cluster 5         [529, 531] cluster 6    [520, 521, 524] cluster 6                525

you can try solution.

new series of remove data created , called remseries.

types of values in lists in series new_orders_list integers , types of other series strings, values converted strings.

then selected rows subsets isin , values added , removed.

print new_orders_list  clusters cluster 1    [525, 526, 533] cluster 2    [527, 528, 532] cluster 3    [519, 534, 535] cluster 4              [530] cluster 5         [529, 531] cluster 6    [520, 521, 524] name: no, dtype: object  print condition  5    525 name: order_id, dtype: object  print condition2  clusters cluster 6    1 name: quant_bought, dtype: int64  #create new series remove remseries = pd.series(condition.values, index = ['cluster 1'], name='rem') print remseries  cluster 1    525 name: rem, dtype: object 
#create dataframe series df = new_orders_list.reset_index() print df      clusters               no 0  cluster 1  [525, 526, 533] 1  cluster 2  [527, 528, 532] 2  cluster 3  [519, 534, 535] 3  cluster 4            [530] 4  cluster 5       [529, 531] 5  cluster 6  [520, 521, 524]  #convert values in list int string df['no'] = df['no'].apply(lambda x: [str(i) in x])  #add , remove items df.loc[df['clusters'].isin(condition2.index.tolist()), 'no'] =  df['no'].apply(lambda x: x + condition.values.tolist())  df.loc[df['clusters'].isin(remseries.index.tolist()), 'no']  =  df['no'].apply(lambda x: [k k in x if k != ''.join(remseries.values)])  #check types of values in list print [ type(x) x in df['no'][0]]  [<type 'str'>, <type 'str'>]  #convert values in list string int df['no'] = df['no'].apply(lambda x: [int(i) in x]) 
print df      clusters                    no 0  cluster 1            [526, 533] 1  cluster 2       [527, 528, 532] 2  cluster 3       [519, 534, 535] 3  cluster 4                 [530] 4  cluster 5            [529, 531] 5  cluster 6  [520, 521, 524, 525]  #check types of values in list print [ type(x) x in df['no'][0]]  [<type 'int'>, <type 'int'>]

Comments

Post a Comment

Popular posts from this blog

c - How to retrieve a variable from the Apache configuration inside the module? -

-
i'm building custom apache module. how retrieve variable apache configuration inside module? see variable "some_var_config_from_apache_or_htaacess" inside apache module: /* source: http://people.apache.org/~humbedooh/mods/examples/mod_example_1.c */ /* include required headers httpd */ #include "httpd.h" #include "http_core.h" #include "http_protocol.h" #include "http_request.h" static void register_hooks(apr_pool_t *pool); static int example_handler(request_rec *r); /* define our module entity , assign function registering hooks */ module ap_module_declare_data example_module = { standard20_module_stuff, null, // per-directory configuration handler null, // merge handler per-directory configurations null, // per-server configuration handler null, // merge handler per-server configurations null, // directives may have httpd register_hoo
Read more

c# - Constructor arguments cannot be passed for interface mocks -

-
when debug code , read line mocklessonplannerafactory creation error: constructor arguments cannot passed interface mocks. var mockschoolclasscodeservice = new mock<ischoolclasscodeservice>(); var mockdateservice = new mock<idateservice>(); var mocklessonplannerafactory = new mock<ilessonplannerafactory>(mockdateservice.object); var mocklessonplannerbfactory = new mock<ilessonplannerbfactory>(mockdateservice.object); var service = new timetableservice(mockunitofwork.object, mocklessonplannerafactory.object, mocklessonplannerbfactory.object, mockschoolclasscodeservice.object); my timetableservice accepts instances of interface type only. mocklessonplannerafactory , bfactory... want in constructor idateservice passed. what wrong code? the clue in error message "constructor arguments cannot passed interface mocks." the mock created interface have default constructor because interfaces don't have constructor. remember mockin
Read more

python - malformed header from script index.py Bad header -

-
i want run python code in apache2(ubuntu 14.04) server. have followed these steps , getting error: step 1: configuration 1: have created directory , file under /var/www/cgi-bin configuration 2 : have edited /etc/apache2/sites-available/000-default.conf alias /cgi-bin /var/www/cgi-bin <directory "/var/www/cgi-bin"> options indexes followsymlinks execcgi addhandler cgi-script .cgi .py allow </directory> <directory /var/www/cgi-bin> options </directory> step 2: and python script is: index.py #!/usr/bin/env python import cgi; import cgitb;cgitb.enable() print "content-type: text/plain\n" print "<b>hello python</b>" step 3: when ran through chrome browser using: url : http://localhost/cgi-bin/index.py step 4: i getting error in error-log malformed header script 'index.py': bad header: hello python you should end header \r\n, must print out yet \r\n signal body coming. (i
Read more