How to use tabulate to format number with thousand separator and right align
0
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 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
add a comment |
0
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 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
add a comment |
0
0
0
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 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
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 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
asked Nov 15 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
asked Nov 15 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
asked Nov 15 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
asked Nov 15 '18 at 16:14
Sean NguyenSean Nguyen
4,503175392
4,503175392
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
0
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 '18 at 17:23
sophrossophros
2,87511133
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 '18 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 '18 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 '18 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 '18 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 '18 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',
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%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
0
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 '18 at 17:23
sophrossophros
2,87511133
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 '18 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 '18 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 '18 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 '18 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 '18 at 20:25
|
show 1 more comment
0
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 '18 at 17:23
sophrossophros
2,87511133
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 '18 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 '18 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 '18 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 '18 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 '18 at 20:25
|
show 1 more comment
0
0
0
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 '18 at 17:23
sophrossophros
2,87511133
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 '18 at 17:23
sophrossophros
2,87511133
edited Nov 15 '18 at 19:24
answered Nov 15 '18 at 17:23
sophrossophros
2,87511133
answered Nov 15 '18 at 17:23
sophrossophros
2,87511133
answered Nov 15 '18 at 17:23
sophrossophros
2,87511133
2,87511133
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 '18 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 '18 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 '18 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 '18 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 '18 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 '18 at 18:45
Usestralignas suggested in the edited answer.
– sophros
Nov 15 '18 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 '18 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 '18 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 '18 at 20:25
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 '18 at 18:45
But this one doesn't do separator on thousand. Do you know how to do that?
– Sean Nguyen
Nov 15 '18 at 18:45
Use
stralign as suggested in the edited answer.– sophros
Nov 15 '18 at 19:24
Use
stralign as suggested in the edited answer.– sophros
Nov 15 '18 at 19:24
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 '18 at 19:47
Can we set the alignment for just one column (size)?
– Sean Nguyen
Nov 15 '18 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 '18 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 '18 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 '18 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 '18 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.
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
