Getting three dots in the CSV

Question

I've saved some data of mine in a csv file using pandas (from a dict) and if I'm looking at it or printing it I'm getting 3 dots in the middle of the information. I think it might be because the string is too long.

Example:

[-1.19583108e-02,  7.44251342e-03, -1.35046719e-02, ..., 1.01258847e-03, -4.75816538e-03,  1.09870630e-02]

When it should've been about 300 different numbers.

Is there any solution?

Explanation: Let's say I have a numpy array of 300 entries (we'll call it arr). I want to store this array in a csv file under the header of test. So I read the csv file (using pd.read_csv function) and try to get this array by using: df['test'].iloc[0]. Now even if I'm using the commands that I was suggested in the answers - I still get dots (because I think it was saved this way). What I actually want to do is to eval this string to get an actual numpy array and use it as an array, but what I get instead is this:

I figured the ellipsis object is the 3 dots I don't want to get.

Does this answer your question? [How do I expand the output display to see more columns of a Pandas DataFrame?](https://stackoverflow.com/questions/11707586/how-do-i-expand-the-output-display-to-see-more-columns-of-a-pandas-dataframe) Also https://stackoverflow.com/q/49188960/4046632 — buran, Sep 19 '21 at 08:52
If the dots are inside the cs file, post the code you actually use to write to the file. Ideally show [mre]. — buran, Sep 19 '21 at 08:55
@azro I don't want to print everything, but when I eval this code I should get an array with about 300 numbers in it, but I get the wrong array — Nikita, Sep 19 '21 at 08:59
When you put it into CSV does these 3 dots appear in the file also? — Pavan Suvarna, Sep 19 '21 at 09:05
No, you did not provide any useful information. Post your code, help us to help you. — buran, Sep 19 '21 at 09:11
My guess is you have problem how you write to file in the first place — buran, Sep 19 '21 at 09:17

U13-Forward · Answer 1 · 2021-09-19T09:11:17.847

1

Just add the following in the beginning of your code:

import sys
numpy.set_printoptions(threshold=sys.maxsize)

Edit:

Try:

df.loc[df[0] != ...]

edited Sep 19 '21 at 09:11

answered Sep 19 '21 at 08:52

U13-Forward

69,221
14
89
114

Getting three dots in the CSV

1 Answers1