Re: Problem of writing long list of lists file to csv

2018-05-22 Thread subhabangalore
On Tuesday, May 22, 2018 at 3:55:58 PM UTC+5:30, Peter Otten wrote:
> 
> 
> > lst2=lst1[:4]
> > with open("my_csv.csv","wb") as f:
> > writer = csv.writer(f)
> > writer.writerows(lst2)
> > 
> > Here it is writing only the first four lists. 
> 
> Hint: look at the first line in the quotation above.

Thank you Sir. Sorry to disturb you. 
-- 
https://mail.python.org/mailman/listinfo/python-list


Re: Problem of writing long list of lists file to csv

2018-05-22 Thread Peter Otten
subhabangal...@gmail.com wrote:

> lst2=lst1[:4]
> with open("my_csv.csv","wb") as f:
> writer = csv.writer(f)
> writer.writerows(lst2)
> 
> Here it is writing only the first four lists. 

Hint: look at the first line in the quotation above. 


-- 
https://mail.python.org/mailman/listinfo/python-list


Problem of writing long list of lists file to csv

2018-05-22 Thread subhabangalore
I have a list of lists (177 lists). 

I am trying to write them as file.

I used the following code to write it in a .csv file.

import  csv
def word2vec_preprocessing():
a1=open("/python27/EngText1.txt","r")
list1=[]
for line in a1:
line1=line.lower().replace(".","").split()
#print line1
list1.append(line1)
lst1=list1
lst2=lst1[:4]
with open("my_csv.csv","wb") as f:
writer = csv.writer(f)
writer.writerows(lst2)

Here it is writing only the first four lists. 

I have searched for help and it seems it is an issue and 
without much of fix. 
Please see the following link. 
https://stackoverflow.com/questions/30711899/python-how-to-write-list-of-lists-to-file

I have now tried pandas and json as follows, but same result. 
my_df = pd.DataFrame(lst2)
my_df.to_csv('sbb_csv.csv', index=False, header=False)

with open('sbb1.json', 'w') as F:
# Use the json dumps method to write the list to disk  
F.write(json.dumps(lst2))
with open('sbb1.json', 'r') as F:
B = json.loads(F.read())

print B


I am using Python 2.7.15 (v2.7.15:ca079a3ea3, Apr 30 2018, 16:22:17) [MSC 
v.1500 32 bit (Intel)] on win32
in MS-Windows.

Please suggest what  error I may be doing? 

Thanking in advance.




-- 
https://mail.python.org/mailman/listinfo/python-list