python - 如何在 python 中打印带有转换值的熊猫表？

Question

在将数据类型（符号、交换和日期）从对象数据类型转换为 float64 数据类型后，我无法在最新数据表中避免 NAN 值。如果您查看我上次打印的数据表，我只会得到 NAN 值，没有我希望的可读数据。有人知道这里可能是什么问题以及如何解决它以便显示可读数据吗？提前致谢！

import requests # For http request to https://marketstack.com
import pandas as pd # For pandas datatable
import numpy as np

# Api Key
params = {
    'access_key': '****************************'
}

# Request Api Key Data
api_result = requests.get('https://api.marketstack.com/v1/eod?access_key=************************&symbols=FB&interval=1min&sort=DESC&limit=1000', params)
api_response = api_result.json()

# Sorts the data into a table
df = pd.DataFrame(api_response['data'])
print(df)

# Exports and then imports csv data
df.to_csv('Test_Sample.csv', index=False)
dataframe = pd.read_csv('Test_Sample.csv', header=0)

#Reverse data table
dataframe2 = dataframe.iloc[::-1]
print(dataframe2)

#Convert string to floats
dataframe2['symbol']=pd.to_numeric(dataframe2['symbol'], errors='coerce')
dataframe2['exchange']=pd.to_numeric(dataframe2['exchange'], errors='coerce')
dataframe2['date']=pd.to_numeric(dataframe2['date'], errors='coerce')

#Display data type and updated table
dataframe2.info()
print(dataframe2)

标签： pythonpandasdataframe