Shift down one row then rename the column
2
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 '18 at 5:54
Phil NguyenPhil Nguyen
323
add a comment |
2
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 '18 at 5:54
Phil NguyenPhil Nguyen
323
because the dataframe is not in the right format.- Can you explain more?
– jezrael
Nov 12 '18 at 6:10
add a comment |
2
2
2
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 '18 at 5:54
Phil NguyenPhil 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 '18 at 5:54
Phil NguyenPhil Nguyen
323
asked Nov 12 '18 at 5:54
Phil NguyenPhil Nguyen
323
asked Nov 12 '18 at 5:54
Phil NguyenPhil Nguyen
323
asked Nov 12 '18 at 5:54
Phil NguyenPhil Nguyen
323
asked Nov 12 '18 at 5:54
Phil NguyenPhil Nguyen
323
323
because the dataframe is not in the right format.- Can you explain more?
– jezrael
Nov 12 '18 at 6:10
add a comment |
because the dataframe is not in the right format.- Can you explain more?
– jezrael
Nov 12 '18 at 6:10
because the dataframe is not in the right format. - Can you explain more?– jezrael
Nov 12 '18 at 6:10
because the dataframe is not in the right format. - Can you explain more?– jezrael
Nov 12 '18 at 6:10
add a comment |
2 Answers
2
active
oldest
votes
1
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 '18 at 6:09
jezraeljezrael
323k23265342
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 '18 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 '18 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 '18 at 6:46
add a comment |
0
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 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
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%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
1
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 '18 at 6:09
jezraeljezrael
323k23265342
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 '18 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 '18 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 '18 at 6:46
add a comment |
1
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 '18 at 6:09
jezraeljezrael
323k23265342
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 '18 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 '18 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 '18 at 6:46
add a comment |
1
1
1
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 '18 at 6:09
jezraeljezrael
323k23265342
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 '18 at 6:09
jezraeljezrael
323k23265342
edited Nov 12 '18 at 6:30
answered Nov 12 '18 at 6:09
jezraeljezrael
323k23265342
answered Nov 12 '18 at 6:09
jezraeljezrael
323k23265342
answered Nov 12 '18 at 6:09
jezraeljezrael
323k23265342
323k23265342
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 '18 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 '18 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 '18 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 '18 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 '18 at 6:32
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 '18 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 '18 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 '18 at 6:24
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 '18 at 6:32
@PhilNguyen - edited answer. Please check it.
– jezrael
Nov 12 '18 at 6:32
1
1
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 '18 at 6:46
It worked! Thanks a lot!
– Phil Nguyen
Nov 12 '18 at 6:46
add a comment |
0
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 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
add a comment |
0
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 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
add a comment |
0
0
0
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 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
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 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
answered Nov 12 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
answered Nov 12 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
answered Nov 12 '18 at 5:57
U9-ForwardU9-Forward
13.6k21337
13.6k21337
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 '18 at 6:10