How to use tabulate to format number with thousand separator and right align
up vote
0
down vote
favorite
I am using tabulate (https://pypi.org/project/tabulate/) and I want to format a number column with thousand separator and right align it. This is what I have done and it doesn't right align my column.
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
df['size'] = df['size'].apply(lambda x: "{:,}".format(x).rjust(15))
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False))
+--------+-------------+
| path | size |
|--------+-------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-------------+
I would like it to be like this:
+--------+-----------------+
| path | size |
|--------+-----------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-----------------+
Thanks,
python-3.x tabulate
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
add a comment |
up vote
0
down vote
favorite
I am using tabulate (https://pypi.org/project/tabulate/) and I want to format a number column with thousand separator and right align it. This is what I have done and it doesn't right align my column.
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
df['size'] = df['size'].apply(lambda x: "{:,}".format(x).rjust(15))
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False))
+--------+-------------+
| path | size |
|--------+-------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-------------+
I would like it to be like this:
+--------+-----------------+
| path | size |
|--------+-----------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-----------------+
Thanks,
python-3.x tabulate
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am using tabulate (https://pypi.org/project/tabulate/) and I want to format a number column with thousand separator and right align it. This is what I have done and it doesn't right align my column.
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
df['size'] = df['size'].apply(lambda x: "{:,}".format(x).rjust(15))
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False))
+--------+-------------+
| path | size |
|--------+-------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-------------+
I would like it to be like this:
+--------+-----------------+
| path | size |
|--------+-----------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-----------------+
Thanks,
python-3.x tabulate
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
I am using tabulate (https://pypi.org/project/tabulate/) and I want to format a number column with thousand separator and right align it. This is what I have done and it doesn't right align my column.
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
df['size'] = df['size'].apply(lambda x: "{:,}".format(x).rjust(15))
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False))
+--------+-------------+
| path | size |
|--------+-------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-------------+
I would like it to be like this:
+--------+-----------------+
| path | size |
|--------+-----------------|
| /etc | 225,612,466 |
| /home | 66 |
+--------+-----------------+
Thanks,
python-3.x tabulate
python-3.x tabulate
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
asked Nov 15 at 16:14
Sean Nguyen
4,296165189
4,296165189
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
I guess the missing parameter in tabulate is numalign="right" but you have to get rid of manual rjust which changes the values to str:
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, numalign="right"))
Gives output:
+--------+-----------+
| path | size |
|--------+-----------|
| /etc | 225612466 |
| /home | 66 |
+--------+-----------+
If you want to keep the thousands separators you have to keep the formatting and align strings to the rigth using stralign:
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, stralign="right"))
answered Nov 15 at 17:23
sophros
1,8741518
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 at 19:47
This really should be another question. And you should have demonstrated some effort of solving the issue. An obvious thing you can try is you can pad your paths on the right so that they appear left-aligned.
– sophros
Nov 15 at 19:52
Sorry, i wasn't clear on my question. You can see on my desired result, the path is left align and i only want to right align my size column with thousand separator. This is just sample dataframe. My data frame has a lot more columns so having the ability to adjust configuration on one column is more desired.
– Sean Nguyen
Nov 15 at 20:25
|
show 1 more 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%2f53323596%2fhow-to-use-tabulate-to-format-number-with-thousand-separator-and-right-align%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I guess the missing parameter in tabulate is numalign="right" but you have to get rid of manual rjust which changes the values to str:
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, numalign="right"))
Gives output:
+--------+-----------+
| path | size |
|--------+-----------|
| /etc | 225612466 |
| /home | 66 |
+--------+-----------+
If you want to keep the thousands separators you have to keep the formatting and align strings to the rigth using stralign:
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, stralign="right"))
answered Nov 15 at 17:23
sophros
1,8741518
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 at 19:47
This really should be another question. And you should have demonstrated some effort of solving the issue. An obvious thing you can try is you can pad your paths on the right so that they appear left-aligned.
– sophros
Nov 15 at 19:52
Sorry, i wasn't clear on my question. You can see on my desired result, the path is left align and i only want to right align my size column with thousand separator. This is just sample dataframe. My data frame has a lot more columns so having the ability to adjust configuration on one column is more desired.
– Sean Nguyen
Nov 15 at 20:25
|
show 1 more comment
up vote
0
down vote
I guess the missing parameter in tabulate is numalign="right" but you have to get rid of manual rjust which changes the values to str:
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, numalign="right"))
Gives output:
+--------+-----------+
| path | size |
|--------+-----------|
| /etc | 225612466 |
| /home | 66 |
+--------+-----------+
If you want to keep the thousands separators you have to keep the formatting and align strings to the rigth using stralign:
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, stralign="right"))
answered Nov 15 at 17:23
sophros
1,8741518
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 at 19:47
This really should be another question. And you should have demonstrated some effort of solving the issue. An obvious thing you can try is you can pad your paths on the right so that they appear left-aligned.
– sophros
Nov 15 at 19:52
Sorry, i wasn't clear on my question. You can see on my desired result, the path is left align and i only want to right align my size column with thousand separator. This is just sample dataframe. My data frame has a lot more columns so having the ability to adjust configuration on one column is more desired.
– Sean Nguyen
Nov 15 at 20:25
|
show 1 more comment
up vote
0
down vote
up vote
0
down vote
I guess the missing parameter in tabulate is numalign="right" but you have to get rid of manual rjust which changes the values to str:
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, numalign="right"))
Gives output:
+--------+-----------+
| path | size |
|--------+-----------|
| /etc | 225612466 |
| /home | 66 |
+--------+-----------+
If you want to keep the thousands separators you have to keep the formatting and align strings to the rigth using stralign:
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, stralign="right"))
answered Nov 15 at 17:23
sophros
1,8741518
I guess the missing parameter in tabulate is numalign="right" but you have to get rid of manual rjust which changes the values to str:
import pandas as pd
rom tabulate import tabulate
df = pd.DataFrame([{'size':225612466, 'path': '/etc'}, {'size':66, 'path': '/home'}])
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, numalign="right"))
Gives output:
+--------+-----------+
| path | size |
|--------+-----------|
| /etc | 225612466 |
| /home | 66 |
+--------+-----------+
If you want to keep the thousands separators you have to keep the formatting and align strings to the rigth using stralign:
print(tabulate(df, headers='keys', tablefmt='psql', showindex=False, stralign="right"))
answered Nov 15 at 17:23
sophros
1,8741518
edited Nov 15 at 19:24
answered Nov 15 at 17:23
sophros
1,8741518
answered Nov 15 at 17:23
sophros
1,8741518
answered Nov 15 at 17:23
sophros
1,8741518
1,8741518
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 at 19:47
This really should be another question. And you should have demonstrated some effort of solving the issue. An obvious thing you can try is you can pad your paths on the right so that they appear left-aligned.
– sophros
Nov 15 at 19:52
Sorry, i wasn't clear on my question. You can see on my desired result, the path is left align and i only want to right align my size column with thousand separator. This is just sample dataframe. My data frame has a lot more columns so having the ability to adjust configuration on one column is more desired.
– Sean Nguyen
Nov 15 at 20:25
|
show 1 more comment
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 at 19:47
This really should be another question. And you should have demonstrated some effort of solving the issue. An obvious thing you can try is you can pad your paths on the right so that they appear left-aligned.
– sophros
Nov 15 at 19:52
Sorry, i wasn't clear on my question. You can see on my desired result, the path is left align and i only want to right align my size column with thousand separator. This is just sample dataframe. My data frame has a lot more columns so having the ability to adjust configuration on one column is more desired.
– Sean Nguyen
Nov 15 at 20:25
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 at 18:45
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 at 18:45
Use
stralign as suggested in the edited answer.– sophros
Nov 15 at 19:24
Use
stralign as suggested in the edited answer.– sophros
Nov 15 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 at 19:47
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 at 19:47
This really should be another question. And you should have demonstrated some effort of solving the issue. An obvious thing you can try is you can pad your paths on the right so that they appear left-aligned.
– sophros
Nov 15 at 19:52
This really should be another question. And you should have demonstrated some effort of solving the issue. An obvious thing you can try is you can pad your paths on the right so that they appear left-aligned.
– sophros
Nov 15 at 19:52
Sorry, i wasn't clear on my question. You can see on my desired result, the path is left align and i only want to right align my size column with thousand separator. This is just sample dataframe. My data frame has a lot more columns so having the ability to adjust configuration on one column is more desired.
– Sean Nguyen
Nov 15 at 20:25
Sorry, i wasn't clear on my question. You can see on my desired result, the path is left align and i only want to right align my size column with thousand separator. This is just sample dataframe. My data frame has a lot more columns so having the ability to adjust configuration on one column is more desired.
– Sean Nguyen
Nov 15 at 20:25
|
show 1 more 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%2f53323596%2fhow-to-use-tabulate-to-format-number-with-thousand-separator-and-right-align%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
