How do I write data to pandas as columns

I'm struggling to write list into a CSV file.
So first of all i convert list to pandas dataframe and now truing to save it as columns to a file, but data is being displayed from new line.
Can you please help me figure out what I've missing in my code

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(lst)

df.to_csv('file.csv', mode='a', index=False, header=False)

Expected result: Name, Age, City

edited Nov 17 '18 at 10:36

jpp

96k2157109

asked Nov 17 '18 at 10:18

Viktor

268214

add a comment |

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(lst)

df.to_csv('file.csv', mode='a', index=False, header=False)

Expected result: Name, Age, City

edited Nov 17 '18 at 10:36

jpp

96k2157109

asked Nov 17 '18 at 10:18

Viktor

268214

add a comment |

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(lst)

df.to_csv('file.csv', mode='a', index=False, header=False)

Expected result: Name, Age, City

edited Nov 17 '18 at 10:36

jpp

96k2157109

asked Nov 17 '18 at 10:18

Viktor

268214

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(lst)

df.to_csv('file.csv', mode='a', index=False, header=False)

Expected result: Name, Age, City

python pandas csv dataframe indexing

edited Nov 17 '18 at 10:36

jpp

96k2157109

asked Nov 17 '18 at 10:18

Viktor

268214

edited Nov 17 '18 at 10:36

jpp

96k2157109

asked Nov 17 '18 at 10:18

Viktor

268214

edited Nov 17 '18 at 10:36

jpp

96k2157109

edited Nov 17 '18 at 10:36

jpp

96k2157109

edited Nov 17 '18 at 10:36

jpp

96k2157109

asked Nov 17 '18 at 10:18

Viktor

268214

asked Nov 17 '18 at 10:18

Viktor

268214

asked Nov 17 '18 at 10:18

Viktor

268214

add a comment |

2 Answers
2

active

oldest

votes

To save as columns, assign your list as columns:

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(columns=lst)



df.to_csv('file.csv', mode='a', index=False)

If not specified, the first argument to pd.DataFrame is data, so you must assign to columns explicitly.

answered Nov 17 '18 at 10:24

jpp

96k2157109

add a comment |

If I understand correctly, you'd just have to add a .T to your line to write the transposed dataframe.

df.T.to_csv('file.csv', mode='a', index=False, header=False)

---^

although if you are using pandas only to write lists as rows to csv files, you'd better have a look at the csv module, because creating intermediary dataframes is pretty pointless.

import csv

lst = ['Name', 'Age', 'City']

with open('file.csv', 'a') as f:

    csv.writer(f).writerow(lst)

edited Nov 17 '18 at 10:28

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

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',
autoActivateHeartbeat: false,
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53350272%2fhow-do-i-write-data-to-pandas-as-columns%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

To save as columns, assign your list as columns:

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(columns=lst)



df.to_csv('file.csv', mode='a', index=False)

If not specified, the first argument to pd.DataFrame is data, so you must assign to columns explicitly.

answered Nov 17 '18 at 10:24

jpp

96k2157109

add a comment |

To save as columns, assign your list as columns:

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(columns=lst)



df.to_csv('file.csv', mode='a', index=False)

If not specified, the first argument to pd.DataFrame is data, so you must assign to columns explicitly.

answered Nov 17 '18 at 10:24

jpp

96k2157109

add a comment |

To save as columns, assign your list as columns:

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(columns=lst)



df.to_csv('file.csv', mode='a', index=False)

If not specified, the first argument to pd.DataFrame is data, so you must assign to columns explicitly.

answered Nov 17 '18 at 10:24

jpp

96k2157109

To save as columns, assign your list as columns:

lst = ['Name', 'Age', 'City']

df = pd.DataFrame(columns=lst)



df.to_csv('file.csv', mode='a', index=False)

If not specified, the first argument to pd.DataFrame is data, so you must assign to columns explicitly.

answered Nov 17 '18 at 10:24

jpp

96k2157109

answered Nov 17 '18 at 10:24

jpp

96k2157109

answered Nov 17 '18 at 10:24

jpp

96k2157109

answered Nov 17 '18 at 10:24

jpp

96k2157109

add a comment |

If I understand correctly, you'd just have to add a .T to your line to write the transposed dataframe.

df.T.to_csv('file.csv', mode='a', index=False, header=False)

---^

although if you are using pandas only to write lists as rows to csv files, you'd better have a look at the csv module, because creating intermediary dataframes is pretty pointless.

import csv

lst = ['Name', 'Age', 'City']

with open('file.csv', 'a') as f:

    csv.writer(f).writerow(lst)

edited Nov 17 '18 at 10:28

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

add a comment |

If I understand correctly, you'd just have to add a .T to your line to write the transposed dataframe.

df.T.to_csv('file.csv', mode='a', index=False, header=False)

---^

although if you are using pandas only to write lists as rows to csv files, you'd better have a look at the csv module, because creating intermediary dataframes is pretty pointless.

import csv

lst = ['Name', 'Age', 'City']

with open('file.csv', 'a') as f:

    csv.writer(f).writerow(lst)

edited Nov 17 '18 at 10:28

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

add a comment |

If I understand correctly, you'd just have to add a .T to your line to write the transposed dataframe.

df.T.to_csv('file.csv', mode='a', index=False, header=False)

---^

although if you are using pandas only to write lists as rows to csv files, you'd better have a look at the csv module, because creating intermediary dataframes is pretty pointless.

import csv

lst = ['Name', 'Age', 'City']

with open('file.csv', 'a') as f:

    csv.writer(f).writerow(lst)

edited Nov 17 '18 at 10:28

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

If I understand correctly, you'd just have to add a .T to your line to write the transposed dataframe.

df.T.to_csv('file.csv', mode='a', index=False, header=False)

---^

although if you are using pandas only to write lists as rows to csv files, you'd better have a look at the csv module, because creating intermediary dataframes is pretty pointless.

import csv

lst = ['Name', 'Age', 'City']

with open('file.csv', 'a') as f:

    csv.writer(f).writerow(lst)

edited Nov 17 '18 at 10:28

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

edited Nov 17 '18 at 10:28

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

answered Nov 17 '18 at 10:21

timgeb

50.5k116392

add a comment |

draft saved

draft discarded

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.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Agfdhyk