How to convert series to dataframe if the series is separated by comma using python?
up vote
0
down vote
favorite
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 |
up vote
0
down vote
favorite
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 |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
up vote
1
down vote
accepted
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 |
up vote
0
down vote
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
772212
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',
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
up vote
1
down vote
accepted
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 |
up vote
1
down vote
accepted
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 |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
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 |
up vote
0
down vote
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
772212
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 |
up vote
0
down vote
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
772212
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 |
up vote
0
down vote
up vote
0
down vote
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
772212
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
772212
edited Nov 22 at 9:54
answered Nov 22 at 9:46
Charles R
772212
answered Nov 22 at 9:46
Charles R
772212
answered Nov 22 at 9:46
Charles R
772212
772212
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