exporting a dataset into a text file in python
up vote
-1
down vote
favorite
I have a list like this example:
mylist = ['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
I am trying to export it into a text file. in fact every string would be one line and every line would have 5 columns. every space separated part in every string would be one column. so, in column 4 there are some comma separated characters and they will be in the same column. and the file would be tab separated.
for the example, the expected output would look like this:
chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4
chr15 76430000 77240000 ETFA,ISL2 4
i am doing that in python using the following code:
with open('outfile.txt', "w") as f:
for item in mylist:
f.write("%sn" % item+ 't')
but it does not return exactly what i want. do you know how to fix it?
python
asked Nov 9 at 13:11
john
917
add a comment |
up vote
-1
down vote
favorite
I have a list like this example:
mylist = ['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
I am trying to export it into a text file. in fact every string would be one line and every line would have 5 columns. every space separated part in every string would be one column. so, in column 4 there are some comma separated characters and they will be in the same column. and the file would be tab separated.
for the example, the expected output would look like this:
chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4
chr15 76430000 77240000 ETFA,ISL2 4
i am doing that in python using the following code:
with open('outfile.txt', "w") as f:
for item in mylist:
f.write("%sn" % item+ 't')
but it does not return exactly what i want. do you know how to fix it?
python
asked Nov 9 at 13:11
john
917
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have a list like this example:
mylist = ['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
I am trying to export it into a text file. in fact every string would be one line and every line would have 5 columns. every space separated part in every string would be one column. so, in column 4 there are some comma separated characters and they will be in the same column. and the file would be tab separated.
for the example, the expected output would look like this:
chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4
chr15 76430000 77240000 ETFA,ISL2 4
i am doing that in python using the following code:
with open('outfile.txt', "w") as f:
for item in mylist:
f.write("%sn" % item+ 't')
but it does not return exactly what i want. do you know how to fix it?
python
asked Nov 9 at 13:11
john
917
I have a list like this example:
mylist = ['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
I am trying to export it into a text file. in fact every string would be one line and every line would have 5 columns. every space separated part in every string would be one column. so, in column 4 there are some comma separated characters and they will be in the same column. and the file would be tab separated.
for the example, the expected output would look like this:
chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4
chr15 76430000 77240000 ETFA,ISL2 4
i am doing that in python using the following code:
with open('outfile.txt', "w") as f:
for item in mylist:
f.write("%sn" % item+ 't')
but it does not return exactly what i want. do you know how to fix it?
python
python
asked Nov 9 at 13:11
john
917
asked Nov 9 at 13:11
john
917
asked Nov 9 at 13:11
john
917
asked Nov 9 at 13:11
john
917
asked Nov 9 at 13:11
john
917
917
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
up vote
2
down vote
accepted
Each of your item is a string e.g. 'chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4'.
I think you'd like to convert the spaces between each column values to tabs. To achive that you should add another nested loop. Something like this:
with open('outfile.txt', "w") as f:
for line in mylist:
for item in line.split(' '):
f.write(item + 't')
f.write("n")
answered Nov 9 at 13:17
lolnoob
945
add a comment |
up vote
3
down vote
This should be fairly simple as follows -
aa=['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
with open("aa.txt","w") as wr:
for item in aa:
wr.write("t".join(item.split(" ")) + "n")
answered Nov 9 at 13:23
Mayur Buragohain
556929
add a comment |
up vote
3
down vote
Instead of:
f.write("%sn" % item+ 't')
Join by tabs after splitting by whitespace:
f.write('t'.join(item.split()) + 'n)
answered Nov 9 at 13:17
RoadRunner
9,44331138
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53226351%2fexporting-a-dataset-into-a-text-file-in-python%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
Each of your item is a string e.g. 'chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4'.
I think you'd like to convert the spaces between each column values to tabs. To achive that you should add another nested loop. Something like this:
with open('outfile.txt', "w") as f:
for line in mylist:
for item in line.split(' '):
f.write(item + 't')
f.write("n")
answered Nov 9 at 13:17
lolnoob
945
add a comment |
up vote
2
down vote
accepted
Each of your item is a string e.g. 'chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4'.
I think you'd like to convert the spaces between each column values to tabs. To achive that you should add another nested loop. Something like this:
with open('outfile.txt', "w") as f:
for line in mylist:
for item in line.split(' '):
f.write(item + 't')
f.write("n")
answered Nov 9 at 13:17
lolnoob
945
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
Each of your item is a string e.g. 'chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4'.
I think you'd like to convert the spaces between each column values to tabs. To achive that you should add another nested loop. Something like this:
with open('outfile.txt', "w") as f:
for line in mylist:
for item in line.split(' '):
f.write(item + 't')
f.write("n")
answered Nov 9 at 13:17
lolnoob
945
Each of your item is a string e.g. 'chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4'.
I think you'd like to convert the spaces between each column values to tabs. To achive that you should add another nested loop. Something like this:
with open('outfile.txt', "w") as f:
for line in mylist:
for item in line.split(' '):
f.write(item + 't')
f.write("n")
answered Nov 9 at 13:17
lolnoob
945
answered Nov 9 at 13:17
lolnoob
945
answered Nov 9 at 13:17
lolnoob
945
answered Nov 9 at 13:17
lolnoob
945
945
add a comment |
add a comment |
up vote
3
down vote
This should be fairly simple as follows -
aa=['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
with open("aa.txt","w") as wr:
for item in aa:
wr.write("t".join(item.split(" ")) + "n")
answered Nov 9 at 13:23
Mayur Buragohain
556929
add a comment |
up vote
3
down vote
This should be fairly simple as follows -
aa=['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
with open("aa.txt","w") as wr:
for item in aa:
wr.write("t".join(item.split(" ")) + "n")
answered Nov 9 at 13:23
Mayur Buragohain
556929
add a comment |
up vote
3
down vote
up vote
3
down vote
This should be fairly simple as follows -
aa=['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
with open("aa.txt","w") as wr:
for item in aa:
wr.write("t".join(item.split(" ")) + "n")
answered Nov 9 at 13:23
Mayur Buragohain
556929
This should be fairly simple as follows -
aa=['chr10 30930000 32110000 ARHGAP12,PFKP,ZEB1,ZNF438 4', 'chr15 76430000 77240000 ETFA,ISL2, 4']
with open("aa.txt","w") as wr:
for item in aa:
wr.write("t".join(item.split(" ")) + "n")
answered Nov 9 at 13:23
Mayur Buragohain
556929
answered Nov 9 at 13:23
Mayur Buragohain
556929
answered Nov 9 at 13:23
Mayur Buragohain
556929
answered Nov 9 at 13:23
Mayur Buragohain
556929
556929
add a comment |
add a comment |
up vote
3
down vote
Instead of:
f.write("%sn" % item+ 't')
Join by tabs after splitting by whitespace:
f.write('t'.join(item.split()) + 'n)
answered Nov 9 at 13:17
RoadRunner
9,44331138
add a comment |
up vote
3
down vote
Instead of:
f.write("%sn" % item+ 't')
Join by tabs after splitting by whitespace:
f.write('t'.join(item.split()) + 'n)
answered Nov 9 at 13:17
RoadRunner
9,44331138
add a comment |
up vote
3
down vote
up vote
3
down vote
Instead of:
f.write("%sn" % item+ 't')
Join by tabs after splitting by whitespace:
f.write('t'.join(item.split()) + 'n)
answered Nov 9 at 13:17
RoadRunner
9,44331138
Instead of:
f.write("%sn" % item+ 't')
Join by tabs after splitting by whitespace:
f.write('t'.join(item.split()) + 'n)
answered Nov 9 at 13:17
RoadRunner
9,44331138
edited Nov 9 at 13:25
answered Nov 9 at 13:17
RoadRunner
9,44331138
answered Nov 9 at 13:17
RoadRunner
9,44331138
answered Nov 9 at 13:17
RoadRunner
9,44331138
9,44331138
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53226351%2fexporting-a-dataset-into-a-text-file-in-python%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
