Pygsheets: Segmentation Fault

Asked Jul 30 '19 at 06:39

Active Jul 30 '19 at 06:39

Viewed 119 times

I am new to python and was trying my hand at something. I am trying to load a google sheet using python and for that I'm using pygsheets.

But whenever I try to load a sheet into a dataframe of Pandas, it's throwing an error: Segmentation Fault (core dumped)

I tried googling many things. It said that this is mostly due to out of memory (RAM) error. But haven't found a way to resolve this.

    gc = pygsheets.authorize(service_file = 'config file name') 
    work_sheet = gc.open('google_sheet_name')
sheet=work_sheet.worksheet_by_title(service)
    all_records = sheet.get_all_records() // this works fine. when I print all_records, I get the desired result.
df = sheet.get_as_df() // throws Segmentation fault.

asked Jul 30 '19 at 06:39

Ayusch

How big is the sheet? Did you try with a smaller sheet? – Nithin Jul 30 '19 at 06:47
are there other non-columnar data like averages or pivot tables in the sheet, if so remove them? – Raveen Beemsingh Jul 30 '19 at 07:23
@nithin Sheet is not that big. 320 rows 11 columns. – Ayusch Jul 30 '19 at 07:43
@Raveen No, there's just text data. – Ayusch Jul 30 '19 at 07:44
please show the exact error message you are getting – Nithin Jul 30 '19 at 10:05
also try running get_all_values on the sheet – Nithin Jul 30 '19 at 10:06
@nithin Already have tried get_all_records() you want me to try get_all_values as well? Also, the error message is: Segmentation Fault (core dumped) Just this line! – Ayusch Jul 30 '19 at 10:08
no, get_all_records call get_call values. Was it working? – Nithin Jul 30 '19 at 10:26
@nithin yes, get_all_values() is working.!! – Ayusch Jul 30 '19 at 11:00
then do df = pd.DataFrame(values) where values is the output of get_all_values – Nithin Jul 30 '19 at 11:13
sheet.get_all_values() now crashes! – Ayusch Jul 30 '19 at 11:24
i think only thing left to do is try in a small sheet (with with a single row and column). you can resize the sheet from pygsheets itself – Nithin Jul 30 '19 at 11:42
@nithin Okay, I'll try that then... – Ayusch Jul 30 '19 at 11:57
@nithin Tried using a file with 2 lines. Shows the same error :( – Ayusch Aug 01 '19 at 10:51
are you using normal python? or cython or something? – Nithin Aug 01 '19 at 12:12
make sure to set `include_tailing_empty` and `include_tailing_empty_rows` to False on `get_all_values ` – Nithin Aug 01 '19 at 12:14

Pygsheets: Segmentation Fault

0 Answers0