Ufdjrw

Today is the Center

Can I use a neutral wire from another outlet to repair a broken neutral?

In a Spin are Both Wings Stalled?

Stopping power of mountain vs road bike

How do I write bicross product symbols in latex?

Why does Kotter return in Welcome Back Kotter

How can I tell someone that I want to be his or her friend?

Anagram holiday

What killed these X2 caps?

What mechanic is there to disable a threat instead of killing it?

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

What is the intuition behind short exact sequences of groups; in particular, what is the intuition behind group extensions?

How can saying a song's name be a copyright violation?

SSH "lag" in LAN on some machines, mixed distros

UK: Is there precedent for the governments e-petition site changing the direction of a government decision?

AES: Why is it a good practice to use only the first 16bytes of a hash for encryption?

Is "remove commented out code" correct English?

How badly should I try to prevent a user from XSSing themselves?

Should I tell management that I intend to leave due to bad software development practices?

How much of data wrangling is a data scientist's job?

Why is consensus so controversial in Britain?

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

Can I ask the recruiters in my resume to put the reason why I am rejected?

Is it possible to download Internet Explorer on my Mac running OS X El Capitan?

Assign incremental integers as Column headers - Python

Calling an external command in PythonWhat are metaclasses in Python?How can I safely create a nested directory in Python?Does Python have a ternary conditional operator?Converting integer to string in Python?Does Python have a string 'contains' substring method?Renaming columns in pandasDelete column from pandas DataFrame by column nameSelect rows from a DataFrame based on values in a column in pandasGet list from pandas DataFrame column headers

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I am trying to automatically assign integers as column headers to a pandas df after a specific string. I can do this manually by reading and counting the amount of columns in any one df. e.g.

df.columns=['X',1,2,3...]

But I want to achieve this automatically without having to count the number of columns. The first column should be a string and then automatically assign incremental integers to the other columns..

I attempted to achieve this using a combination of @kudeh's suggestion.

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

But this returns an error:

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

TypeError: must be str, not list

Intended Output:

df.columns = ['X',1,2,3...]

python pandas dataframe int assign

share|improve this question

edited Mar 8 at 0:29

jonboy

asked Mar 7 at 23:54

jonboyjonboy

32112

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have to manually count the columns and insert df.columns['X',1,2,n]. I want to automatically assign the columns without having to count them.
  
  – jonboy
  Mar 8 at 0:31
  

  
  
  
  

add a comment | 

0

I am trying to automatically assign integers as column headers to a pandas df after a specific string. I can do this manually by reading and counting the amount of columns in any one df. e.g.

df.columns=['X',1,2,3...]

But I want to achieve this automatically without having to count the number of columns. The first column should be a string and then automatically assign incremental integers to the other columns..

I attempted to achieve this using a combination of @kudeh's suggestion.

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

But this returns an error:

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

TypeError: must be str, not list

Intended Output:

df.columns = ['X',1,2,3...]

python pandas dataframe int assign

share|improve this question

edited Mar 8 at 0:29

jonboy

asked Mar 7 at 23:54

jonboyjonboy

32112

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have to manually count the columns and insert df.columns['X',1,2,n]. I want to automatically assign the columns without having to count them.
  
  – jonboy
  Mar 8 at 0:31
  

  
  
  
  

add a comment | 

I am trying to automatically assign integers as column headers to a pandas df after a specific string. I can do this manually by reading and counting the amount of columns in any one df. e.g.

df.columns=['X',1,2,3...]

But I want to achieve this automatically without having to count the number of columns. The first column should be a string and then automatically assign incremental integers to the other columns..

I attempted to achieve this using a combination of @kudeh's suggestion.

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

But this returns an error:

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

TypeError: must be str, not list

Intended Output:

df.columns = ['X',1,2,3...]

python pandas dataframe int assign

share|improve this question

edited Mar 8 at 0:29

jonboy

asked Mar 7 at 23:54

jonboyjonboy

32112

df.columns=['X',1,2,3...]

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

df.columns = 'X' + [i for i in range(1,len(df.columns)+1)]

TypeError: must be str, not list

df.columns = ['X',1,2,3...]

share|improve this question

edited Mar 8 at 0:29

jonboy

asked Mar 7 at 23:54

jonboyjonboy

32112

share|improve this question

edited Mar 8 at 0:29

jonboy

asked Mar 7 at 23:54

jonboyjonboy

32112

asked Mar 7 at 23:54

jonboyjonboy

32112

asked Mar 7 at 23:54

jonboyjonboy

32112

1 Answer
1

active

oldest

votes

1

cols = ['X']
otherCols = [i for i in range(1,len(df.columns))]
cols.extend(otherCols)

df.columns = cols

share|improve this answer

edited Mar 8 at 0:33

answered Mar 8 at 0:09

kudehkudeh

350110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry @kudeh. I didn't explain the question properly. I've amended it now
  
  – jonboy
  Mar 8 at 0:20
  

  
  
  
  

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55054680%2fassign-incremental-integers-as-column-headers-python%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

cols = ['X']
otherCols = [i for i in range(1,len(df.columns))]
cols.extend(otherCols)

df.columns = cols

share|improve this answer

edited Mar 8 at 0:33

answered Mar 8 at 0:09

kudehkudeh

350110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry @kudeh. I didn't explain the question properly. I've amended it now
  
  – jonboy
  Mar 8 at 0:20
  

  
  
  
  

add a comment | 

1

cols = ['X']
otherCols = [i for i in range(1,len(df.columns))]
cols.extend(otherCols)

df.columns = cols

share|improve this answer

edited Mar 8 at 0:33

answered Mar 8 at 0:09

kudehkudeh

350110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry @kudeh. I didn't explain the question properly. I've amended it now
  
  – jonboy
  Mar 8 at 0:20
  

  
  
  
  

add a comment | 

cols = ['X']
otherCols = [i for i in range(1,len(df.columns))]
cols.extend(otherCols)

df.columns = cols

share|improve this answer

edited Mar 8 at 0:33

answered Mar 8 at 0:09

kudehkudeh

350110

cols = ['X']
otherCols = [i for i in range(1,len(df.columns))]
cols.extend(otherCols)

df.columns = cols

share|improve this answer

edited Mar 8 at 0:33

answered Mar 8 at 0:09

kudehkudeh

350110

answered Mar 8 at 0:09

kudehkudeh

350110

answered Mar 8 at 0:09

kudehkudeh

350110