How to insert two columns in a CSV File using python? -


i want insert 2 columns in new csv file. question1 data should in first column , question2 data should in second column

below given code gives me output:

['question1']

['what', 'step', 'step', 'guide', 'invest', 'share', 'market', 'india']

['what', 'story', 'kohinoor', 'kohinoor', 'diamond']

['how', 'i', 'increase', 'speed', 'internet', 'connection', 'using', 'vpn']

['why', 'i', 'mentally', 'lonely', 'how', 'i', 'solve']

['which', 'one', 'dissolve', 'water', 'quikly', 'sugar', 'salt', 'methane', 'carbon', 'di', 'oxide']

['astrology', 'i', 'capricorn', 'sun', 'cap', 'moon', 'cap', 'rising', 'say']

['should', 'i', 'buy', 'tiago']

['how', 'i', 'good', 'geologist']

['when', 'use', 'ã‚·', 'instead', 'ã—']

['question2']

['what', 'step', 'step', 'guide', 'invest', 'share', 'market']

['what', 'would', 'happen', 'indian', 'government', 'stole', 'kohinoor', 'kohinoor', 'diamond', 'back']

['how', 'internet', 'speed', 'increased', 'hacking', 'dns']

['find', 'remainder', 'math', '23', '24', 'math', 'divided', '2423']

['which', 'fish', 'would', 'survive', 'salt', 'water']

['i', 'triple', 'capricorn', 'sun', 'moon', 'ascendant', 'capricorn', 'what', 'say']

['what', 'keeps', 'childern', 'active', 'far', 'phone', 'video', 'games']

['what', 'i', 'great', 'geologist']

['when', 'use', 'instead']

here code:

question1="\n".join(map(str, tokenized_reports_no_stopwords1)) question2="\n".join(map(str, tokenized_reports_no_stopwords2)) col1=question1.split("\n") col2=question2.split("\n") open("outputfile.csv" , mode="wt", encoding='utf-8') out_file:      w=csv.writer(out_file)      row in col1:          mycolumns = row.split("\n")          print(mycolumns)          w.writerow(mycolumns)      row in col2:          mycolumns = row.split("\n")          print(mycolumns)          w.writerow(mycolumns)

the output should this: question1 should in first column of csv , question 2 should in second column of csv file

['question1'] ['question2']

['what', 'step', 'step', 'guide', 'invest', 'share', 'market', 'india'] ['what', 'step', 'step', 'guide', 'invest', 'share', 'market']

['what', 'story', 'kohinoor', 'kohinoor', 'diamond'] ['what', 'would', 'happen', 'indian', 'government', 'stole', 'kohinoor', 'kohinoor', 'diamond', 'back']

['how', 'i', 'increase', 'speed', 'internet', 'connection', 'using', 'vpn'] ['how', 'internet', 'speed', 'increased', 'hacking', 'dns']

['why', 'i', 'mentally', 'lonely', 'how', 'i', 'solve'] ['find', 'remainder', 'math', '23', '24', 'math', 'divided', '2423']

['which', 'one', 'dissolve', 'water', 'quikly', 'sugar', 'salt', 'methane', 'carbon', 'di', 'oxide'] ['which', 'fish', 'would', 'survive', 'salt', 'water']

['astrology', 'i', 'capricorn', 'sun', 'cap', 'moon', 'cap', 'rising', 'say'] ['i', 'triple', 'capricorn', 'sun', 'moon', 'ascendant', 'capricorn', 'what', 'say']

['should', 'i', 'buy', 'tiago'] ['what', 'keeps', 'childern', 'active', 'far', 'phone', 'video', 'games']

['how', 'i', 'good', 'geologist'] ['what', 'i', 'great', 'geologist']

['when', 'use', 'ã‚·', 'instead', 'ã—'] ['when', 'use', 'instead']

please me how can solve problem..

ypu can use pandas this.

import pandas pd  question1 = [['1', '1'], ['1', '2', '3'], ['3', '4']]   #question 1 data question2 = [['is', 'was'], ['i', 'am', 'me'],['yes', 'no']] #question 2 data  df = pd.dataframe(columns=["question1", "question2"]) df["question1"] = question1 df["question2"] = question2  df.to_csv("output.csv", index=false)

output.csv

question1,question2 "['1', '1']","['is', 'was']" "['1', '2', '3']","['i', 'am', 'me']" "['3', '4']","['yes', 'no']"

Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj...
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer ...
Read more

c# - Asp.net web api : redirect unauthorized requst to forbidden page -

im trying redirect unauthorized request forbidden page instead i'm getting forbidden page in response body , how can fix ? here's startup class : app.createperowincontext(storecontext.create); app.createperowincontext<applicationusermanager>(applicationusermanager.create); app.createperowincontext<applicationsigninmanager>(applicationsigninmanager.create); app.usecookieauthentication(new cookieauthenticationoptions { authenticationtype = defaultauthenticationtypes.applicationcookie, expiretimespan = timespan.fromdays(30), }); app.useexternalsignincookie(defaultauthenticationtypes.externalcookie); app.usetwofactorsignincookie(defaultauthenticationtypes.twofactorcookie, timespan.fromminutes(5)); app.usetwofactorrememberbrowsercookie(defaultauthenticationtypes.twofactorrememberbrowsercookie); the method im trying reach : [httpget] [authorize(roles = "admin")] public string getcurrentusername() { return userman...
Read more