Shift down one row then rename the column
up vote
2
down vote
favorite
My data is looking like this:
pd.read_csv('/Users/admin/desktop/007538839.csv').head()
105586.18
0 105582.910
1 105585.230
2 105576.445
3 105580.016
4 105580.266
I want to move that 105568.18 to the 0 index because now it is the column name. And after that I want to name this column 'flux'. I've tried
pd.read_csv('/Users/admin/desktop/007538839.csv', sep='t', names = ["flux"])
but it did not work, probably because the dataframe is not in the right format.
How can I achieve that?
python pandas
asked Nov 12 at 5:54
Phil Nguyen
323
add a comment |
up vote
2
down vote
favorite
My data is looking like this:
pd.read_csv('/Users/admin/desktop/007538839.csv').head()
105586.18
0 105582.910
1 105585.230
2 105576.445
3 105580.016
4 105580.266
I want to move that 105568.18 to the 0 index because now it is the column name. And after that I want to name this column 'flux'. I've tried
pd.read_csv('/Users/admin/desktop/007538839.csv', sep='t', names = ["flux"])
but it did not work, probably because the dataframe is not in the right format.
How can I achieve that?
python pandas
asked Nov 12 at 5:54
Phil Nguyen
323
because the dataframe is not in the right format.- Can you explain more?
– jezrael
Nov 12 at 6:10
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
My data is looking like this:
pd.read_csv('/Users/admin/desktop/007538839.csv').head()
105586.18
0 105582.910
1 105585.230
2 105576.445
3 105580.016
4 105580.266
I want to move that 105568.18 to the 0 index because now it is the column name. And after that I want to name this column 'flux'. I've tried
pd.read_csv('/Users/admin/desktop/007538839.csv', sep='t', names = ["flux"])
but it did not work, probably because the dataframe is not in the right format.
How can I achieve that?
python pandas
asked Nov 12 at 5:54
Phil Nguyen
323
My data is looking like this:
pd.read_csv('/Users/admin/desktop/007538839.csv').head()
105586.18
0 105582.910
1 105585.230
2 105576.445
3 105580.016
4 105580.266
I want to move that 105568.18 to the 0 index because now it is the column name. And after that I want to name this column 'flux'. I've tried
pd.read_csv('/Users/admin/desktop/007538839.csv', sep='t', names = ["flux"])
but it did not work, probably because the dataframe is not in the right format.
How can I achieve that?
python pandas
python pandas
asked Nov 12 at 5:54
Phil Nguyen
323
asked Nov 12 at 5:54
Phil Nguyen
323
asked Nov 12 at 5:54
Phil Nguyen
323
asked Nov 12 at 5:54
Phil Nguyen
323
asked Nov 12 at 5:54
Phil Nguyen
323
323
because the dataframe is not in the right format.- Can you explain more?
– jezrael
Nov 12 at 6:10
add a comment |
because the dataframe is not in the right format.- Can you explain more?
– jezrael
Nov 12 at 6:10
because the dataframe is not in the right format. - Can you explain more?– jezrael
Nov 12 at 6:10
because the dataframe is not in the right format. - Can you explain more?– jezrael
Nov 12 at 6:10
add a comment |
2 Answers
2
active
oldest
votes
up vote
1
down vote
accepted
For me your code working very nice:
import pandas as pd
temp=u"""105586.18
105582.910
105585.230
105576.445
105580.016
105580.266"""
#after testing replace 'pd.compat.StringIO(temp)' to '/Users/admin/desktop/007538839.csv'
df = pd.read_csv(pd.compat.StringIO(temp), sep='t', names = ["flux"])
print (df)
flux
0 105586.180
1 105582.910
2 105585.230
3 105576.445
4 105580.016
5 105580.266
For overwrite original file with same data with new header flux:
df.to_csv('/Users/admin/desktop/007538839.csv', index=False)
answered Nov 12 at 6:09
jezrael
316k22256333
Thanks a lot! I thought it didn't work because I am actually trying to write this df back to the original csv file. So when I used read_csv() to read the file again I found nothing changed. My bad! Can you show me how to overwrite the original file with this new df?
– Phil Nguyen
Nov 12 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 at 6:46
add a comment |
up vote
0
down vote
Try this:
df=pd.read_csv('/Users/admin/desktop/007538839.csv',header=None)
df.columns=['flux']
header=None is the friend of yours.
answered Nov 12 at 5:57
U9-Forward
11.5k2834
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%2f53256547%2fshift-down-one-row-then-rename-the-column%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
For me your code working very nice:
import pandas as pd
temp=u"""105586.18
105582.910
105585.230
105576.445
105580.016
105580.266"""
#after testing replace 'pd.compat.StringIO(temp)' to '/Users/admin/desktop/007538839.csv'
df = pd.read_csv(pd.compat.StringIO(temp), sep='t', names = ["flux"])
print (df)
flux
0 105586.180
1 105582.910
2 105585.230
3 105576.445
4 105580.016
5 105580.266
For overwrite original file with same data with new header flux:
df.to_csv('/Users/admin/desktop/007538839.csv', index=False)
answered Nov 12 at 6:09
jezrael
316k22256333
Thanks a lot! I thought it didn't work because I am actually trying to write this df back to the original csv file. So when I used read_csv() to read the file again I found nothing changed. My bad! Can you show me how to overwrite the original file with this new df?
– Phil Nguyen
Nov 12 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 at 6:46
add a comment |
up vote
1
down vote
accepted
For me your code working very nice:
import pandas as pd
temp=u"""105586.18
105582.910
105585.230
105576.445
105580.016
105580.266"""
#after testing replace 'pd.compat.StringIO(temp)' to '/Users/admin/desktop/007538839.csv'
df = pd.read_csv(pd.compat.StringIO(temp), sep='t', names = ["flux"])
print (df)
flux
0 105586.180
1 105582.910
2 105585.230
3 105576.445
4 105580.016
5 105580.266
For overwrite original file with same data with new header flux:
df.to_csv('/Users/admin/desktop/007538839.csv', index=False)
answered Nov 12 at 6:09
jezrael
316k22256333
Thanks a lot! I thought it didn't work because I am actually trying to write this df back to the original csv file. So when I used read_csv() to read the file again I found nothing changed. My bad! Can you show me how to overwrite the original file with this new df?
– Phil Nguyen
Nov 12 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 at 6:46
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
For me your code working very nice:
import pandas as pd
temp=u"""105586.18
105582.910
105585.230
105576.445
105580.016
105580.266"""
#after testing replace 'pd.compat.StringIO(temp)' to '/Users/admin/desktop/007538839.csv'
df = pd.read_csv(pd.compat.StringIO(temp), sep='t', names = ["flux"])
print (df)
flux
0 105586.180
1 105582.910
2 105585.230
3 105576.445
4 105580.016
5 105580.266
For overwrite original file with same data with new header flux:
df.to_csv('/Users/admin/desktop/007538839.csv', index=False)
answered Nov 12 at 6:09
jezrael
316k22256333
For me your code working very nice:
import pandas as pd
temp=u"""105586.18
105582.910
105585.230
105576.445
105580.016
105580.266"""
#after testing replace 'pd.compat.StringIO(temp)' to '/Users/admin/desktop/007538839.csv'
df = pd.read_csv(pd.compat.StringIO(temp), sep='t', names = ["flux"])
print (df)
flux
0 105586.180
1 105582.910
2 105585.230
3 105576.445
4 105580.016
5 105580.266
For overwrite original file with same data with new header flux:
df.to_csv('/Users/admin/desktop/007538839.csv', index=False)
answered Nov 12 at 6:09
jezrael
316k22256333
edited Nov 12 at 6:30
answered Nov 12 at 6:09
jezrael
316k22256333
answered Nov 12 at 6:09
jezrael
316k22256333
answered Nov 12 at 6:09
jezrael
316k22256333
316k22256333
Thanks a lot! I thought it didn't work because I am actually trying to write this df back to the original csv file. So when I used read_csv() to read the file again I found nothing changed. My bad! Can you show me how to overwrite the original file with this new df?
– Phil Nguyen
Nov 12 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 at 6:46
add a comment |
Thanks a lot! I thought it didn't work because I am actually trying to write this df back to the original csv file. So when I used read_csv() to read the file again I found nothing changed. My bad! Can you show me how to overwrite the original file with this new df?
– Phil Nguyen
Nov 12 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 at 6:46
Thanks a lot! I thought it didn't work because I am actually trying to write this df back to the original csv file. So when I used read_csv() to read the file again I found nothing changed. My bad! Can you show me how to overwrite the original file with this new df?
– Phil Nguyen
Nov 12 at 6:24
Thanks a lot! I thought it didn't work because I am actually trying to write this df back to the original csv file. So when I used read_csv() to read the file again I found nothing changed. My bad! Can you show me how to overwrite the original file with this new df?
– Phil Nguyen
Nov 12 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 at 6:32
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 at 6:32
1
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 at 6:46
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 at 6:46
add a comment |
up vote
0
down vote
Try this:
df=pd.read_csv('/Users/admin/desktop/007538839.csv',header=None)
df.columns=['flux']
header=None is the friend of yours.
answered Nov 12 at 5:57
U9-Forward
11.5k2834
add a comment |
up vote
0
down vote
Try this:
df=pd.read_csv('/Users/admin/desktop/007538839.csv',header=None)
df.columns=['flux']
header=None is the friend of yours.
answered Nov 12 at 5:57
U9-Forward
11.5k2834
add a comment |
up vote
0
down vote
up vote
0
down vote
Try this:
df=pd.read_csv('/Users/admin/desktop/007538839.csv',header=None)
df.columns=['flux']
header=None is the friend of yours.
answered Nov 12 at 5:57
U9-Forward
11.5k2834
Try this:
df=pd.read_csv('/Users/admin/desktop/007538839.csv',header=None)
df.columns=['flux']
header=None is the friend of yours.
answered Nov 12 at 5:57
U9-Forward
11.5k2834
answered Nov 12 at 5:57
U9-Forward
11.5k2834
answered Nov 12 at 5:57
U9-Forward
11.5k2834
answered Nov 12 at 5:57
U9-Forward
11.5k2834
11.5k2834
add a comment |
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%2f53256547%2fshift-down-one-row-then-rename-the-column%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
because the dataframe is not in the right format.- Can you explain more?– jezrael
Nov 12 at 6:10