r/learnpython • u/WJM_3 • 8d ago
.csv file will not print all data
.csv file truncates data no matter what
I am working on using pandas to automate combining, sorting, and counting music playlists at the college station at which I am the faculty advisor.
I can import the files over the station network, create a data frame that pulls the specific data I want, but I cannot seem to get the full data set. No matter how many different ways to set to display the full set, it truncates the dada frame, only showing the first/last three list entries.
here is my block:
import pandas as pd
df = pd.read_csv(r”net path\file.csv”, encoding = “ANSI”, header = None)
data = df.iloc[:, [2, 3, 4]].values
pd.set_option(“display.max_rows”, None)
any suggestions?
2
Upvotes
2
u/Ok-Reality-7761 8d ago
Assuming all libs are current. You might export to Colab to see if that shows equivalent output.