'I was working on my college python project. question is about pandas dataframe manipulation. check body for full details
that 'time' column in dataframe is in str format. I want to plot that time frame with relation to 'price' column. any suggestions. I'm stuck!
I'm using python 3.10 & jupyter notebook
import pandas as pd
import numpy as np
from sqlalchemy import create_engine
cnx = create_engine('sqlite:///BTCUSDT.db').connect()
df = pd.read_sql_table('BTCUSDT', cnx)
df[['date','time']] = df['time'].str.split(' ', expand=True)
df
another code in background getting the price in 'BTCUSDT.db' file. thanks.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|