Date display with pandas

[Jacques2101]

Summary

I have a dataframe with date as index. When I tried to print it with st.write(data) I have te date which include the time ie 2003-03-25 00:00:00
I would like to have a normal data ie 2003-03-25 or even March 25 2003

[ferdy]

Have a look on this example.

from datetime import datetime

import streamlit as st
import pandas as pd


# Build an example dataframe with datetime column.

# Init data.
data = {
    'Date': [datetime.strptime('2023-02-17 10:45:00', '%Y-%m-%d %H:%M:%S'),
             datetime.strptime('2023-02-18 10:30:00', '%Y-%m-%d %H:%M:%S')],
    'Count': [4, 6]
}

# Convert data to pandas dataframe.
df = pd.DataFrame(data)

# Set Date as index.
df = df.set_index('Date')

st.write('### Init dataframe')
st.write(df)

# Set index as date.
df.index = df.index.date

st.write('### Index as date')
st.write(df)

Output

[Jacques2101]

Thx a lot. How to change the format to yyyy-mm-dd to dd-mm-yyyy ? And how to change the columns format (width of comlumns…)

Thanks a lot

Cordialement

[ferdy]

Change date format.

from datetime import datetime

import streamlit as st
import pandas as pd


# Build an example dataframe with datetime column.

# Init data.
data = {
    'Date': [datetime.strptime('2023-02-17 10:45:00', '%Y-%m-%d %H:%M:%S'),
             datetime.strptime('2023-02-18 10:30:00', '%Y-%m-%d %H:%M:%S')],
    'Count': [4, 6]
}

# Convert data to pandas dataframe.
df = pd.DataFrame(data)

# Set Date as index.
df = df.set_index('Date')

st.write('### Init dataframe')
st.write(df)

# Reset the index to get the Date column back.
df = df.reset_index()
st.write('### Restored Date column')
st.write(df)

# Modify the Date format
df['Date'] = df['Date'].dt.strftime('%d-%m-%Y')

# Set Date as index again.
df = df.set_index('Date')

st.write('### Index as date in dd-mm-yyyy format')
st.write(df)

Output

[ferdy]

@Jacques2101

And how to change the columns format (width of comlumns…)

Have a look on dataframe and aggrid.

[Jacques2101]

Ok. Thx

An other question : with st.date_input() how to format the date in dd/mm/aaaa instead of yyyy/mm/dd ?

Thx a lot.

Cordialement