python - Place the data with respect to its variable (column) -

- 

customerid  cs_cookie   cs_referer      cs_host sc_status   sc_substatus    sc_win32_status sc_bytes    cs_bytes       1     kommarajula http    rewardcenter    200  0             0               3189           2767          62         2     kommarajula http    rewardcenter    200  0             0              61828           2767         156         2     kommarajula http    rewardcenter    200  0             0               3445           2750          62         3     kommarajula http    rewardcenter    200  0             0              19738           2782          78         4     kommarajula http    rewardcenter    200  0             0              19738           2781          78         5     kommarajula v1:1    rewardcenter    200  0             0              51396           2253         374         6     kommarajula v1:1    rewardcenter    200  0             0               2357           2201         124         7     kommarajula v1:1    rewardcenter    200  0             0              19594           2243         140         8     kommarajula ram v1:1    rewardcenter    200            0                 0            22778       2425          109    9     kommarajula ram v1:1    rewardcenter    200            0                 0            28186       2460          296   10     kommarajula ram kumar   v1:1    rewardcenter          200                0              0         28186         2460    296  11     kommarajula ram kumar   v1:1    rewardcenter          200                0              0         28186         2460    296

i have iis log data in csv format, "cs_cookie" variable has spilled in many columns, want place data in corresponding variable after deleting "cs_cookie" variable. please me.

new_columns = iis.columns.values[0:24].tolist() count=[] in range(len(iis['customerid'])): iis_list = [] iis_list = iis.loc[i].tolist() iis_list = [x x in iis_list if str(x) != 'nan'] count.append(len(iis_list))  iis['count']=count out_list = []  in iis.values.tolist(): if i[len(iis.columns)-1] > 24:     out_list.append(i[0:16]+i[28:36]) else:     out_list.append(i[0:24])  new_df = pd.dataframe(out_list) new_df.columns = new_columns

Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

python - pip wont install .WHL files -

-
when try install .whl gohike typing cmd c:\users\owner\downloads>pip install ta_lib-0.4.9-cp27-none-win_amd64.whl i print out: `processing c:\users\owner\downloads\ta_lib-0.4.9-cp27-none-win_amd64.whl complete output command python setup.py egg_info: traceback <most recent call last>: file "<string>", line 1, in <module> ioerror: [errno 2] no such file or directory:'c:\\users\\owner\\appdata\\lo cal\\temp\\pip-9gwk2c-build\\setup.py' ----------------------------------------- command "python setup.py egg_info" failed error code 1 in c:\users\owner\ap pdata\local\temp\pip-9gwk2c-build\` the part between pip- , -build in pip-9gwk2c-build different on same file. i asked python 2.7.11 pip 8.0.3 can't install gohike whl of ta-lib 0.4.9 few days ago , decided ask differently. can me! you have outdated pip not understand wheels. wheels not supposed have setup.py inside. try upgrading pip pip in...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more