OSDir


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Problem of writing long list of lists file to csv


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.