csv - Copying data to another column in Python/Pandas -


i have ip packet csv file i'm trying extract sequence numbers info field separate column has sequence numbers. sequence numbers substring in middle of info string. here raw code.. first create new column fo sequence numbers, check if info field contains seq number, split info field sequence number out. if print after 'seq = j.split...', correct values. how write csv file seq column? 

file = pd.read_csv(file.csv)  file['seq'] = none in file['info']:     if 'seq' in i:         split = i.split(' ')         j in split:             if 'seq=' in j:                 seq = j.split('seq=',1)[1]                 file.loc[i,'seq'] = int(seq)

example csv:

no. time        source      destination protocol    length  info   1   0.000000    sourceip    192.168.0.1 tcp         54      35165 > 80 [syn] seq=0 win=16384 len=0   2   0.000001    sourceip    192.168.0.1 tcp         54      14378 > 80 [syn] seq=0 win=16384 len=0   3   0.000003    sourceip    192.168.0.1 tcp         54      31944 > 80 [syn] seq=0 win=16384 len=0

desired outcome:

no. time        source      destination protocol    length  info                                   seq   1   0.000000    sourceip    192.168.0.1 tcp         54      35165 > 80 [syn] seq=0 win=16384 len=0 0   2   0.000001    sourceip    192.168.0.1 tcp         54      14378 > 80 [syn] seq=0 win=16384 len=0 0   3   0.000003    sourceip    192.168.0.1 tcp         54      31944 > 80 [syn] seq=0 win=16384 len=0 0

use str.extract

file['seq'] = file.info.str.extract('seq=(\d+)', expand=false).astype(float)

-

Comments

Post a Comment

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

i have custom members system have made: yii2 members system . can refer full details, or install can work question. i have frontend , backend yii2 provides, few modifications separate sessions/cookies backend works admin model , pulls admin table. similar old traditional member systems. mainsite clone of frontend , it's role main website. when go www.site.com or site.com . here 3 apps , example domains: mainsite = www.site.com or site.com frontend = users.site.com backend = admin.site.com when user logs in ( users.site.com/site/login ) , go homepage ( mainsite @ www.site.com ) want know logged in , show username. how frontend operates default advanced app. from have far, login , head mainsite , reads an internal server error occurred. . doesn't yii error, server error? when in yii logs under runtime, mentions access control: 2017-04-14 13:38:25 [127.0.0.1][1][-][error][yii\web\httpexception:403] exception 'yii\web\forbiddenhttpexception'...
Read more

angular - password and confirm password field validation angular2 reactive forms -

i need check whether password , confirm password fields have same value using reactive form angular2. did see lot of answers on same here, angular 2 form validating repeat password , comparing fields in validator angular2 , none seemed work me.can please help."this" undefined in validate function :( . sharing code, this.addedituserform = this.builder.group({ firstname: ['', validators.required], lastname: ['', validators.required], title: ['', validators.required], email: ['', validators.required], password: ['', validators.required], confirmpass: ['', [validators.required, this.validatepasswordconfirmation]] }); validatepasswordconfirmation(group: formgroup): any{ let valid = true; // if (this.addedituserform.controls.password != this.addedituserform.controls.confirmpass) { // valid = false; // this.add...
Read more

php - Permission denied. Laravel linux server -

when try register , send email user got error. working till yesterday. today gives me , cant figure out why. way on local testing work's. i'm stuck. please errorexception in compiled.php line 7512: file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied in compiled.php line 7512 @ handleexceptions->handleerror('2', 'file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied', '/var/www/html/bootstrap/cache/compiled.php', '7512', array('path' => '/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php', 'contents' => 'please activate account clicking on following link. <a href="<?php echo e(route('auth.activate', $token)); ?>"><?php echo e(route('auth.activate', $token)); ?...
Read more