How to convert series to dataframe if the series is separated by comma using python?
0
Converting series to dataframe:
I tried this:
df = pd.Series(data)
df1=pd.DataFrame(df,sep=",")
print(df1)
This is the series format:
0 (The Associated Press, Shock in Japan as Nissa...
1 (The Associated Press, Shock in Japan as Nissa...
2 (The Associated Press, Venezuelan ambassador t...
3 (None, WATCH: World News 11/19/18: Deadly Shoo...
4 (The Associated Press, AP Photos: Northeastern...
5 (The Associated Press, Esi Edugyan wins prize ...
6 (The Associated Press, China's Xi visits Manil...
python python-3.x pandas
edited Nov 22 at 9:39
Joe
5,81421129
asked Nov 22 at 9:38
Harini
178
add a comment |
0
Converting series to dataframe:
I tried this:
df = pd.Series(data)
df1=pd.DataFrame(df,sep=",")
print(df1)
This is the series format:
0 (The Associated Press, Shock in Japan as Nissa...
1 (The Associated Press, Shock in Japan as Nissa...
2 (The Associated Press, Venezuelan ambassador t...
3 (None, WATCH: World News 11/19/18: Deadly Shoo...
4 (The Associated Press, AP Photos: Northeastern...
5 (The Associated Press, Esi Edugyan wins prize ...
6 (The Associated Press, China's Xi visits Manil...
python python-3.x pandas
edited Nov 22 at 9:39
Joe
5,81421129
asked Nov 22 at 9:38
Harini
178
1
What isprint (data[:3])?
– jezrael
Nov 22 at 9:40
Does my answer fit to your need ?
– Charles R
Nov 22 at 12:55
add a comment |
0
0
0
Converting series to dataframe:
I tried this:
df = pd.Series(data)
df1=pd.DataFrame(df,sep=",")
print(df1)
This is the series format:
0 (The Associated Press, Shock in Japan as Nissa...
1 (The Associated Press, Shock in Japan as Nissa...
2 (The Associated Press, Venezuelan ambassador t...
3 (None, WATCH: World News 11/19/18: Deadly Shoo...
4 (The Associated Press, AP Photos: Northeastern...
5 (The Associated Press, Esi Edugyan wins prize ...
6 (The Associated Press, China's Xi visits Manil...
python python-3.x pandas
edited Nov 22 at 9:39
Joe
5,81421129
asked Nov 22 at 9:38
Harini
178
Converting series to dataframe:
I tried this:
df = pd.Series(data)
df1=pd.DataFrame(df,sep=",")
print(df1)
This is the series format:
0 (The Associated Press, Shock in Japan as Nissa...
1 (The Associated Press, Shock in Japan as Nissa...
2 (The Associated Press, Venezuelan ambassador t...
3 (None, WATCH: World News 11/19/18: Deadly Shoo...
4 (The Associated Press, AP Photos: Northeastern...
5 (The Associated Press, Esi Edugyan wins prize ...
6 (The Associated Press, China's Xi visits Manil...
python python-3.x pandas
python python-3.x pandas
edited Nov 22 at 9:39
Joe
5,81421129
asked Nov 22 at 9:38
Harini
178
edited Nov 22 at 9:39
Joe
5,81421129
asked Nov 22 at 9:38
Harini
178
edited Nov 22 at 9:39
Joe
5,81421129
edited Nov 22 at 9:39
Joe
5,81421129
edited Nov 22 at 9:39
Joe
5,81421129
5,81421129
asked Nov 22 at 9:38
Harini
178
asked Nov 22 at 9:38
Harini
178
asked Nov 22 at 9:38
Harini
178
178
1
What isprint (data[:3])?
– jezrael
Nov 22 at 9:40
Does my answer fit to your need ?
– Charles R
Nov 22 at 12:55
add a comment |
1
What isprint (data[:3])?
– jezrael
Nov 22 at 9:40
Does my answer fit to your need ?
– Charles R
Nov 22 at 12:55
1
1
What is
print (data[:3]) ?– jezrael
Nov 22 at 9:40
What is
print (data[:3]) ?– jezrael
Nov 22 at 9:40
Does my answer fit to your need ?
– Charles R
Nov 22 at 12:55
Does my answer fit to your need ?
– Charles R
Nov 22 at 12:55
add a comment |
2 Answers
2
active
oldest
votes
1
pd.DataFrame(df.tolist())
since the series is in a list format.This line works.
Output:
0 1
0 The Associated Press Shock in Japan as Nissan's Ghosn held in..
1 The Associated Press Shock in Japan as Nissan's Ghosn held..
2 The Associated Press Venezuelan ambassador to Cuba Ali Rodriguez..
3 None WATCH: World News 11/19/18: Deadly Shooting...
answered Nov 23 at 6:25
Harini
178
add a comment |
0
df1 = pd.DataFrame(data)
df1 = df1.replace({'(': '', ')': ''})
df1 = df1[0].str.split(',',expand=True)
df1 = df1.rename(columns={0: 'col1', 1: 'col2'})
print(df1)
answered Nov 22 at 9:46
Charles R
825213
Please provide some context.
– Matthieu Brucher
Nov 22 at 10:08
i am fetching the data from database and displaying it in series and want to convert it to dataframe
– Harini
Nov 23 at 5:56
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');
});
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%2f53427854%2fhow-to-convert-series-to-dataframe-if-the-series-is-separated-by-comma-using-pyt%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
pd.DataFrame(df.tolist())
since the series is in a list format.This line works.
Output:
0 1
0 The Associated Press Shock in Japan as Nissan's Ghosn held in..
1 The Associated Press Shock in Japan as Nissan's Ghosn held..
2 The Associated Press Venezuelan ambassador to Cuba Ali Rodriguez..
3 None WATCH: World News 11/19/18: Deadly Shooting...
answered Nov 23 at 6:25
Harini
178
add a comment |
1
pd.DataFrame(df.tolist())
since the series is in a list format.This line works.
Output:
0 1
0 The Associated Press Shock in Japan as Nissan's Ghosn held in..
1 The Associated Press Shock in Japan as Nissan's Ghosn held..
2 The Associated Press Venezuelan ambassador to Cuba Ali Rodriguez..
3 None WATCH: World News 11/19/18: Deadly Shooting...
answered Nov 23 at 6:25
Harini
178
add a comment |
1
1
1
pd.DataFrame(df.tolist())
since the series is in a list format.This line works.
Output:
0 1
0 The Associated Press Shock in Japan as Nissan's Ghosn held in..
1 The Associated Press Shock in Japan as Nissan's Ghosn held..
2 The Associated Press Venezuelan ambassador to Cuba Ali Rodriguez..
3 None WATCH: World News 11/19/18: Deadly Shooting...
answered Nov 23 at 6:25
Harini
178
pd.DataFrame(df.tolist())
since the series is in a list format.This line works.
Output:
0 1
0 The Associated Press Shock in Japan as Nissan's Ghosn held in..
1 The Associated Press Shock in Japan as Nissan's Ghosn held..
2 The Associated Press Venezuelan ambassador to Cuba Ali Rodriguez..
3 None WATCH: World News 11/19/18: Deadly Shooting...
answered Nov 23 at 6:25
Harini
178
answered Nov 23 at 6:25
Harini
178
answered Nov 23 at 6:25
Harini
178
answered Nov 23 at 6:25
Harini
178
178
add a comment |
add a comment |
0
df1 = pd.DataFrame(data)
df1 = df1.replace({'(': '', ')': ''})
df1 = df1[0].str.split(',',expand=True)
df1 = df1.rename(columns={0: 'col1', 1: 'col2'})
print(df1)
answered Nov 22 at 9:46
Charles R
825213
Please provide some context.
– Matthieu Brucher
Nov 22 at 10:08
i am fetching the data from database and displaying it in series and want to convert it to dataframe
– Harini
Nov 23 at 5:56
add a comment |
0
df1 = pd.DataFrame(data)
df1 = df1.replace({'(': '', ')': ''})
df1 = df1[0].str.split(',',expand=True)
df1 = df1.rename(columns={0: 'col1', 1: 'col2'})
print(df1)
answered Nov 22 at 9:46
Charles R
825213
Please provide some context.
– Matthieu Brucher
Nov 22 at 10:08
i am fetching the data from database and displaying it in series and want to convert it to dataframe
– Harini
Nov 23 at 5:56
add a comment |
0
0
0
df1 = pd.DataFrame(data)
df1 = df1.replace({'(': '', ')': ''})
df1 = df1[0].str.split(',',expand=True)
df1 = df1.rename(columns={0: 'col1', 1: 'col2'})
print(df1)
answered Nov 22 at 9:46
Charles R
825213
df1 = pd.DataFrame(data)
df1 = df1.replace({'(': '', ')': ''})
df1 = df1[0].str.split(',',expand=True)
df1 = df1.rename(columns={0: 'col1', 1: 'col2'})
print(df1)
answered Nov 22 at 9:46
Charles R
825213
edited Nov 22 at 9:54
answered Nov 22 at 9:46
Charles R
825213
answered Nov 22 at 9:46
Charles R
825213
answered Nov 22 at 9:46
Charles R
825213
825213
Please provide some context.
– Matthieu Brucher
Nov 22 at 10:08
i am fetching the data from database and displaying it in series and want to convert it to dataframe
– Harini
Nov 23 at 5:56
add a comment |
Please provide some context.
– Matthieu Brucher
Nov 22 at 10:08
i am fetching the data from database and displaying it in series and want to convert it to dataframe
– Harini
Nov 23 at 5:56
Please provide some context.
– Matthieu Brucher
Nov 22 at 10:08
Please provide some context.
– Matthieu Brucher
Nov 22 at 10:08
i am fetching the data from database and displaying it in series and want to convert it to dataframe
– Harini
Nov 23 at 5:56
i am fetching the data from database and displaying it in series and want to convert it to dataframe
– Harini
Nov 23 at 5:56
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.
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.
draft saved
draft discarded
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%2f53427854%2fhow-to-convert-series-to-dataframe-if-the-series-is-separated-by-comma-using-pyt%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
1
What is
print (data[:3])?– jezrael
Nov 22 at 9:40
Does my answer fit to your need ?
– Charles R
Nov 22 at 12:55