应用df.iloc（）后转换为“nan”的数据帧值

Question

nan values

在运行pd.DataFrame（）之后，我遇到了一个问题，整个数据帧变成了“nan”（空）。我再也不能扭转这种局面了。我还为数据框列指定了名称，但它们的值也消失了：

    import pandas as pd
    import numpy as np
    import matplotlib.pyplot as plt

    df = pd.read_csv('PuntaCapi.csv', header=None, sep='\n')
    df = df[0].str.split(',', expand=True)
    df.to_csv("PuntaCapi.tab",sep="\t",header=None, index=False)
    print(df)

    Akim =df.iloc[:,0:1] 

    A= pd.DataFrame(data =Akim ,columns=['Akim'])

    veriler2 = pd.DataFrame(data = df, columns=['Akim','Kuvvet','Zaman','Soguma','Yaklasma','Baski','SacKalinliği','PuntaCapi'])
    print(veriler2)

请查看上述代码的以下结果： [！[Spyder视图数据帧代码[][2][2]1

There is no nan value into the csv file. But after .iloc[], entire dataframe became nan value. I have tried solve the problem but I could not. I need help to solve problem 在此处输入图像描述

Answer 1

我不明白你的问题

使用pd.read_csv('PuntaCapi.csv', header=None, sep='\n')读取数据并将其保存为df，但将df修改为df[0].str.split(',', expand=True)，这将直接影响结果

试试这个代码

df = pd.read_csv('PuntaCapi.csv', header=None, sep='\n')
veriler2 = pd.DataFrame(data = df.values, columns=['Akim','Kuvvet','Zaman','Soguma','Yaklasma','Baski','SacKalinliği','PuntaCapi'])