How to print pandas DataFrame without index
86
I want to print the whole dataframe, but I don't want to print the index
Besides, one column is datetime type, I just want to print time, not date.
The dataframe looks like:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:18:00 893
2 123 2014-07-08 00:49:00 1041
I want it print as
User ID Enter Time Activity Number
123 00:09:00 1411
123 00:18:00 893
123 00:49:00 1041
python datetime pandas dataframe
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
add a comment |
86
I want to print the whole dataframe, but I don't want to print the index
Besides, one column is datetime type, I just want to print time, not date.
The dataframe looks like:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:18:00 893
2 123 2014-07-08 00:49:00 1041
I want it print as
User ID Enter Time Activity Number
123 00:09:00 1411
123 00:18:00 893
123 00:49:00 1041
python datetime pandas dataframe
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
1
You are using terminology ("data frame", "index") that make me think you are actually working in R, not Python. Please clarify. Regardless, we need to see the existing code that prints this "data frame" to have any chance at all of being able to help. Please read and follow the instructions at stackoverflow.com/help/mcve
– zwol
Jul 9 '14 at 2:59
... I will say that if this is actually Python and those aredatetime.datetimeobjects in the second column, then you can print just the time using thestrftimemethod, with an appropriate format string (probably"%H:%M:%S").
– zwol
Jul 9 '14 at 3:02
9
@Zack:DataFrameis the name of the 2D data structure inpandas, a popular Python data analysis library.
– DSM
Jul 9 '14 at 3:09
1
Yes, It is pandas...
– lserlohn
Jul 9 '14 at 3:37
add a comment |
86
86
86
16
I want to print the whole dataframe, but I don't want to print the index
Besides, one column is datetime type, I just want to print time, not date.
The dataframe looks like:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:18:00 893
2 123 2014-07-08 00:49:00 1041
I want it print as
User ID Enter Time Activity Number
123 00:09:00 1411
123 00:18:00 893
123 00:49:00 1041
python datetime pandas dataframe
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
I want to print the whole dataframe, but I don't want to print the index
Besides, one column is datetime type, I just want to print time, not date.
The dataframe looks like:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:18:00 893
2 123 2014-07-08 00:49:00 1041
I want it print as
User ID Enter Time Activity Number
123 00:09:00 1411
123 00:18:00 893
123 00:49:00 1041
python datetime pandas dataframe
python datetime pandas dataframe
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
edited Aug 9 '18 at 10:33
Aaron McDaid
19.3k54876
19.3k54876
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
asked Jul 9 '14 at 2:50
lserlohnlserlohn
1,23341733
1,23341733
1
You are using terminology ("data frame", "index") that make me think you are actually working in R, not Python. Please clarify. Regardless, we need to see the existing code that prints this "data frame" to have any chance at all of being able to help. Please read and follow the instructions at stackoverflow.com/help/mcve
– zwol
Jul 9 '14 at 2:59
... I will say that if this is actually Python and those aredatetime.datetimeobjects in the second column, then you can print just the time using thestrftimemethod, with an appropriate format string (probably"%H:%M:%S").
– zwol
Jul 9 '14 at 3:02
9
@Zack:DataFrameis the name of the 2D data structure inpandas, a popular Python data analysis library.
– DSM
Jul 9 '14 at 3:09
1
Yes, It is pandas...
– lserlohn
Jul 9 '14 at 3:37
add a comment |
1
You are using terminology ("data frame", "index") that make me think you are actually working in R, not Python. Please clarify. Regardless, we need to see the existing code that prints this "data frame" to have any chance at all of being able to help. Please read and follow the instructions at stackoverflow.com/help/mcve
– zwol
Jul 9 '14 at 2:59
... I will say that if this is actually Python and those aredatetime.datetimeobjects in the second column, then you can print just the time using thestrftimemethod, with an appropriate format string (probably"%H:%M:%S").
– zwol
Jul 9 '14 at 3:02
9
@Zack:DataFrameis the name of the 2D data structure inpandas, a popular Python data analysis library.
– DSM
Jul 9 '14 at 3:09
1
Yes, It is pandas...
– lserlohn
Jul 9 '14 at 3:37
1
1
You are using terminology ("data frame", "index") that make me think you are actually working in R, not Python. Please clarify. Regardless, we need to see the existing code that prints this "data frame" to have any chance at all of being able to help. Please read and follow the instructions at stackoverflow.com/help/mcve
– zwol
Jul 9 '14 at 2:59
You are using terminology ("data frame", "index") that make me think you are actually working in R, not Python. Please clarify. Regardless, we need to see the existing code that prints this "data frame" to have any chance at all of being able to help. Please read and follow the instructions at stackoverflow.com/help/mcve
– zwol
Jul 9 '14 at 2:59
... I will say that if this is actually Python and those are
datetime.datetime objects in the second column, then you can print just the time using the strftime method, with an appropriate format string (probably "%H:%M:%S").– zwol
Jul 9 '14 at 3:02
... I will say that if this is actually Python and those are
datetime.datetime objects in the second column, then you can print just the time using the strftime method, with an appropriate format string (probably "%H:%M:%S").– zwol
Jul 9 '14 at 3:02
9
9
@Zack:
DataFrame is the name of the 2D data structure in pandas, a popular Python data analysis library.– DSM
Jul 9 '14 at 3:09
@Zack:
DataFrame is the name of the 2D data structure in pandas, a popular Python data analysis library.– DSM
Jul 9 '14 at 3:09
1
1
Yes, It is pandas...
– lserlohn
Jul 9 '14 at 3:37
Yes, It is pandas...
– lserlohn
Jul 9 '14 at 3:37
add a comment |
4 Answers
4
active
oldest
votes
125
print df.to_string(index=False)
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
6
This is nice, however it does not contain the tab-sep anymore which is than a handicap when copying to excel
– Rockbar
Oct 5 '17 at 12:30
2
@Rockbar if you want to copy/export to excel you should be usingdf.to_csvanyway.
– U2EF1
Nov 18 '17 at 1:07
1
For me the column labels come out not justified to the data (there are spaces missing at the start). Maybe because my data takes up more characters than the column label. Adding the argument justify='left' fixes it, though obviously changes the alignment of the column labels.
– ErnestScribbler
Dec 10 '18 at 13:17
You can also usedf.to_clipboard()and then paste into Excel. Useful for dealing with Windows's stupid "you can't edit an open document" BS.
– BallpointBen
Jan 18 at 23:42
add a comment |
22
print(df.to_csv(sep='t', index=False))
Or possibly:
print(df.to_csv(columns=['A', 'B', 'C'], sep='t', index=False))
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
1
How is this possible as DataFrame.to_csv does not have a return value? I get only None printed out.
– jung rhew
Nov 26 '18 at 18:28
add a comment |
3
If you just want a string/json to print it can be solved with:
print(df.to_string(index=False))
Buf if you want to serialize the data too or even send to a MongoDB, would be better to do something like:
document = df.to_dict(orient='list')
There are 6 ways by now to orient the data, check more in the panda docs which better fits you.
answered Aug 17 '17 at 16:51
ZiulZiul
775
add a comment |
0
To answer the "How to print dataframe without an index" question, you can set the index to be an array of empty strings (one for each row in the dataframe), like this:
blankIndex=[''] * len(df)
df.index=blankIndex
If we use the data from your post:
row1 = (123, '2014-07-08 00:09:00', 1411)
row2 = (123, '2014-07-08 00:49:00', 1041)
row3 = (123, '2014-07-08 00:09:00', 1411)
data = [row1, row2, row3]
#set up dataframe
df = pd.DataFrame(data, columns=('User ID', 'Enter Time', 'Activity Number'))
print(df)
which would normally print out as:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:49:00 1041
2 123 2014-07-08 00:09:00 1411
By creating an array with as many empty strings as there are rows in the data frame:
blankIndex=[''] * len(df)
df.index=blankIndex
print(df)
It will remove the index from the output:
User ID Enter Time Activity Number
123 2014-07-08 00:09:00 1411
123 2014-07-08 00:49:00 1041
123 2014-07-08 00:09:00 1411
And in Jupyter Notebooks would render as per this screenshot:
Juptyer Notebooks dataframe with no index column
answered Feb 26 at 21:11
rojroj
412213
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%2f24644656%2fhow-to-print-pandas-dataframe-without-index%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
125
print df.to_string(index=False)
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
6
This is nice, however it does not contain the tab-sep anymore which is than a handicap when copying to excel
– Rockbar
Oct 5 '17 at 12:30
2
@Rockbar if you want to copy/export to excel you should be usingdf.to_csvanyway.
– U2EF1
Nov 18 '17 at 1:07
1
For me the column labels come out not justified to the data (there are spaces missing at the start). Maybe because my data takes up more characters than the column label. Adding the argument justify='left' fixes it, though obviously changes the alignment of the column labels.
– ErnestScribbler
Dec 10 '18 at 13:17
You can also usedf.to_clipboard()and then paste into Excel. Useful for dealing with Windows's stupid "you can't edit an open document" BS.
– BallpointBen
Jan 18 at 23:42
add a comment |
125
print df.to_string(index=False)
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
6
This is nice, however it does not contain the tab-sep anymore which is than a handicap when copying to excel
– Rockbar
Oct 5 '17 at 12:30
2
@Rockbar if you want to copy/export to excel you should be usingdf.to_csvanyway.
– U2EF1
Nov 18 '17 at 1:07
1
For me the column labels come out not justified to the data (there are spaces missing at the start). Maybe because my data takes up more characters than the column label. Adding the argument justify='left' fixes it, though obviously changes the alignment of the column labels.
– ErnestScribbler
Dec 10 '18 at 13:17
You can also usedf.to_clipboard()and then paste into Excel. Useful for dealing with Windows's stupid "you can't edit an open document" BS.
– BallpointBen
Jan 18 at 23:42
add a comment |
125
125
125
print df.to_string(index=False)
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
print df.to_string(index=False)
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
edited Sep 18 '15 at 23:39
Walery Strauch
3,88263549
3,88263549
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
answered Sep 18 '15 at 23:09
Pavol ZibritaPavol Zibrita
1,266164
1,266164
6
This is nice, however it does not contain the tab-sep anymore which is than a handicap when copying to excel
– Rockbar
Oct 5 '17 at 12:30
2
@Rockbar if you want to copy/export to excel you should be usingdf.to_csvanyway.
– U2EF1
Nov 18 '17 at 1:07
1
For me the column labels come out not justified to the data (there are spaces missing at the start). Maybe because my data takes up more characters than the column label. Adding the argument justify='left' fixes it, though obviously changes the alignment of the column labels.
– ErnestScribbler
Dec 10 '18 at 13:17
You can also usedf.to_clipboard()and then paste into Excel. Useful for dealing with Windows's stupid "you can't edit an open document" BS.
– BallpointBen
Jan 18 at 23:42
add a comment |
6
This is nice, however it does not contain the tab-sep anymore which is than a handicap when copying to excel
– Rockbar
Oct 5 '17 at 12:30
2
@Rockbar if you want to copy/export to excel you should be usingdf.to_csvanyway.
– U2EF1
Nov 18 '17 at 1:07
1
For me the column labels come out not justified to the data (there are spaces missing at the start). Maybe because my data takes up more characters than the column label. Adding the argument justify='left' fixes it, though obviously changes the alignment of the column labels.
– ErnestScribbler
Dec 10 '18 at 13:17
You can also usedf.to_clipboard()and then paste into Excel. Useful for dealing with Windows's stupid "you can't edit an open document" BS.
– BallpointBen
Jan 18 at 23:42
6
6
This is nice, however it does not contain the tab-sep anymore which is than a handicap when copying to excel
– Rockbar
Oct 5 '17 at 12:30
This is nice, however it does not contain the tab-sep anymore which is than a handicap when copying to excel
– Rockbar
Oct 5 '17 at 12:30
2
2
@Rockbar if you want to copy/export to excel you should be using
df.to_csv anyway.– U2EF1
Nov 18 '17 at 1:07
@Rockbar if you want to copy/export to excel you should be using
df.to_csv anyway.– U2EF1
Nov 18 '17 at 1:07
1
1
For me the column labels come out not justified to the data (there are spaces missing at the start). Maybe because my data takes up more characters than the column label. Adding the argument justify='left' fixes it, though obviously changes the alignment of the column labels.
– ErnestScribbler
Dec 10 '18 at 13:17
For me the column labels come out not justified to the data (there are spaces missing at the start). Maybe because my data takes up more characters than the column label. Adding the argument justify='left' fixes it, though obviously changes the alignment of the column labels.
– ErnestScribbler
Dec 10 '18 at 13:17
You can also use
df.to_clipboard() and then paste into Excel. Useful for dealing with Windows's stupid "you can't edit an open document" BS.– BallpointBen
Jan 18 at 23:42
You can also use
df.to_clipboard() and then paste into Excel. Useful for dealing with Windows's stupid "you can't edit an open document" BS.– BallpointBen
Jan 18 at 23:42
add a comment |
22
print(df.to_csv(sep='t', index=False))
Or possibly:
print(df.to_csv(columns=['A', 'B', 'C'], sep='t', index=False))
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
1
How is this possible as DataFrame.to_csv does not have a return value? I get only None printed out.
– jung rhew
Nov 26 '18 at 18:28
add a comment |
22
print(df.to_csv(sep='t', index=False))
Or possibly:
print(df.to_csv(columns=['A', 'B', 'C'], sep='t', index=False))
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
1
How is this possible as DataFrame.to_csv does not have a return value? I get only None printed out.
– jung rhew
Nov 26 '18 at 18:28
add a comment |
22
22
22
print(df.to_csv(sep='t', index=False))
Or possibly:
print(df.to_csv(columns=['A', 'B', 'C'], sep='t', index=False))
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
print(df.to_csv(sep='t', index=False))
Or possibly:
print(df.to_csv(columns=['A', 'B', 'C'], sep='t', index=False))
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
answered Jul 9 '14 at 6:39
U2EF1U2EF1
8,1032535
8,1032535
1
How is this possible as DataFrame.to_csv does not have a return value? I get only None printed out.
– jung rhew
Nov 26 '18 at 18:28
add a comment |
1
How is this possible as DataFrame.to_csv does not have a return value? I get only None printed out.
– jung rhew
Nov 26 '18 at 18:28
1
1
How is this possible as DataFrame.to_csv does not have a return value? I get only None printed out.
– jung rhew
Nov 26 '18 at 18:28
How is this possible as DataFrame.to_csv does not have a return value? I get only None printed out.
– jung rhew
Nov 26 '18 at 18:28
add a comment |
3
If you just want a string/json to print it can be solved with:
print(df.to_string(index=False))
Buf if you want to serialize the data too or even send to a MongoDB, would be better to do something like:
document = df.to_dict(orient='list')
There are 6 ways by now to orient the data, check more in the panda docs which better fits you.
answered Aug 17 '17 at 16:51
ZiulZiul
775
add a comment |
3
If you just want a string/json to print it can be solved with:
print(df.to_string(index=False))
Buf if you want to serialize the data too or even send to a MongoDB, would be better to do something like:
document = df.to_dict(orient='list')
There are 6 ways by now to orient the data, check more in the panda docs which better fits you.
answered Aug 17 '17 at 16:51
ZiulZiul
775
add a comment |
3
3
3
If you just want a string/json to print it can be solved with:
print(df.to_string(index=False))
Buf if you want to serialize the data too or even send to a MongoDB, would be better to do something like:
document = df.to_dict(orient='list')
There are 6 ways by now to orient the data, check more in the panda docs which better fits you.
answered Aug 17 '17 at 16:51
ZiulZiul
775
If you just want a string/json to print it can be solved with:
print(df.to_string(index=False))
Buf if you want to serialize the data too or even send to a MongoDB, would be better to do something like:
document = df.to_dict(orient='list')
There are 6 ways by now to orient the data, check more in the panda docs which better fits you.
answered Aug 17 '17 at 16:51
ZiulZiul
775
answered Aug 17 '17 at 16:51
ZiulZiul
775
answered Aug 17 '17 at 16:51
ZiulZiul
775
answered Aug 17 '17 at 16:51
ZiulZiul
775
775
add a comment |
add a comment |
0
To answer the "How to print dataframe without an index" question, you can set the index to be an array of empty strings (one for each row in the dataframe), like this:
blankIndex=[''] * len(df)
df.index=blankIndex
If we use the data from your post:
row1 = (123, '2014-07-08 00:09:00', 1411)
row2 = (123, '2014-07-08 00:49:00', 1041)
row3 = (123, '2014-07-08 00:09:00', 1411)
data = [row1, row2, row3]
#set up dataframe
df = pd.DataFrame(data, columns=('User ID', 'Enter Time', 'Activity Number'))
print(df)
which would normally print out as:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:49:00 1041
2 123 2014-07-08 00:09:00 1411
By creating an array with as many empty strings as there are rows in the data frame:
blankIndex=[''] * len(df)
df.index=blankIndex
print(df)
It will remove the index from the output:
User ID Enter Time Activity Number
123 2014-07-08 00:09:00 1411
123 2014-07-08 00:49:00 1041
123 2014-07-08 00:09:00 1411
And in Jupyter Notebooks would render as per this screenshot:
Juptyer Notebooks dataframe with no index column
answered Feb 26 at 21:11
rojroj
412213
add a comment |
0
To answer the "How to print dataframe without an index" question, you can set the index to be an array of empty strings (one for each row in the dataframe), like this:
blankIndex=[''] * len(df)
df.index=blankIndex
If we use the data from your post:
row1 = (123, '2014-07-08 00:09:00', 1411)
row2 = (123, '2014-07-08 00:49:00', 1041)
row3 = (123, '2014-07-08 00:09:00', 1411)
data = [row1, row2, row3]
#set up dataframe
df = pd.DataFrame(data, columns=('User ID', 'Enter Time', 'Activity Number'))
print(df)
which would normally print out as:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:49:00 1041
2 123 2014-07-08 00:09:00 1411
By creating an array with as many empty strings as there are rows in the data frame:
blankIndex=[''] * len(df)
df.index=blankIndex
print(df)
It will remove the index from the output:
User ID Enter Time Activity Number
123 2014-07-08 00:09:00 1411
123 2014-07-08 00:49:00 1041
123 2014-07-08 00:09:00 1411
And in Jupyter Notebooks would render as per this screenshot:
Juptyer Notebooks dataframe with no index column
answered Feb 26 at 21:11
rojroj
412213
add a comment |
0
0
0
To answer the "How to print dataframe without an index" question, you can set the index to be an array of empty strings (one for each row in the dataframe), like this:
blankIndex=[''] * len(df)
df.index=blankIndex
If we use the data from your post:
row1 = (123, '2014-07-08 00:09:00', 1411)
row2 = (123, '2014-07-08 00:49:00', 1041)
row3 = (123, '2014-07-08 00:09:00', 1411)
data = [row1, row2, row3]
#set up dataframe
df = pd.DataFrame(data, columns=('User ID', 'Enter Time', 'Activity Number'))
print(df)
which would normally print out as:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:49:00 1041
2 123 2014-07-08 00:09:00 1411
By creating an array with as many empty strings as there are rows in the data frame:
blankIndex=[''] * len(df)
df.index=blankIndex
print(df)
It will remove the index from the output:
User ID Enter Time Activity Number
123 2014-07-08 00:09:00 1411
123 2014-07-08 00:49:00 1041
123 2014-07-08 00:09:00 1411
And in Jupyter Notebooks would render as per this screenshot:
Juptyer Notebooks dataframe with no index column
answered Feb 26 at 21:11
rojroj
412213
To answer the "How to print dataframe without an index" question, you can set the index to be an array of empty strings (one for each row in the dataframe), like this:
blankIndex=[''] * len(df)
df.index=blankIndex
If we use the data from your post:
row1 = (123, '2014-07-08 00:09:00', 1411)
row2 = (123, '2014-07-08 00:49:00', 1041)
row3 = (123, '2014-07-08 00:09:00', 1411)
data = [row1, row2, row3]
#set up dataframe
df = pd.DataFrame(data, columns=('User ID', 'Enter Time', 'Activity Number'))
print(df)
which would normally print out as:
User ID Enter Time Activity Number
0 123 2014-07-08 00:09:00 1411
1 123 2014-07-08 00:49:00 1041
2 123 2014-07-08 00:09:00 1411
By creating an array with as many empty strings as there are rows in the data frame:
blankIndex=[''] * len(df)
df.index=blankIndex
print(df)
It will remove the index from the output:
User ID Enter Time Activity Number
123 2014-07-08 00:09:00 1411
123 2014-07-08 00:49:00 1041
123 2014-07-08 00:09:00 1411
And in Jupyter Notebooks would render as per this screenshot:
Juptyer Notebooks dataframe with no index column
answered Feb 26 at 21:11
rojroj
412213
answered Feb 26 at 21:11
rojroj
412213
answered Feb 26 at 21:11
rojroj
412213
answered Feb 26 at 21:11
rojroj
412213
412213
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.
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%2f24644656%2fhow-to-print-pandas-dataframe-without-index%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
1
You are using terminology ("data frame", "index") that make me think you are actually working in R, not Python. Please clarify. Regardless, we need to see the existing code that prints this "data frame" to have any chance at all of being able to help. Please read and follow the instructions at stackoverflow.com/help/mcve
– zwol
Jul 9 '14 at 2:59
... I will say that if this is actually Python and those are
datetime.datetimeobjects in the second column, then you can print just the time using thestrftimemethod, with an appropriate format string (probably"%H:%M:%S").– zwol
Jul 9 '14 at 3:02
9
@Zack:
DataFrameis the name of the 2D data structure inpandas, a popular Python data analysis library.– DSM
Jul 9 '14 at 3:09
1
Yes, It is pandas...
– lserlohn
Jul 9 '14 at 3:37