Giter Club home page Giter Club logo

Comments (7)

robin900 avatar robin900 commented on June 3, 2024

@Laila92 Thanks for reporting your problem. Would you be able to attach your rawData18Sheet.csv file here? Or perhaps even just the first three lines of it, including the header? I want to reproduce your problem using your own data file's column structure.

from gspread-dataframe.

robin900 avatar robin900 commented on June 3, 2024

Also @Laila92 -- if one of your columns in the input CSV file is named 'Client', then include_index=True merely means not to omit the Client column in the written Google worksheet. If instead you use an implicit index column, by omitting index_col='Client', then you'll see an additional column added to the worksheet via include_index=True. If this answers your question, hooray; if not, let me know and attach if you can a sample of your input CSV file.

from gspread-dataframe.

Laila92 avatar Laila92 commented on June 3, 2024

I can get the Client column to appear if I do not set is as an index, but I prefer having that column as the index of my dataframe. Why, if I set index_col='Client', does include_index=True not make the client column show up in the google sheet?

from gspread-dataframe.

Laila92 avatar Laila92 commented on June 3, 2024
Client has service? year month traffic Source Leads Bad Leads Sold Gross new leads type conversion rate closing rate                        
Example_client x 2018 January 18978 DEALER 355 7 23 $16,708.32 362 website 0.01907471809 0.0635359116                        
Example_client x 2018 January 18978 Lives In Area 111 0 48 $72,054.06 111 other 0.005848877648 0.4324324324                        
Example_client x 2018 January 18978 Sales 86 0 84 $93,160.23 86 other 0.004531562862 0.976744186                        

from gspread-dataframe.

robin900 avatar robin900 commented on June 3, 2024

@Laila92 Thanks for the extra info; I'll give you an update today (NYC time).

from gspread-dataframe.

robin900 avatar robin900 commented on June 3, 2024

@Laila92 I've released to PyPI version 3.0.2 of gspread-dataframe with a fix (including test coverage) for your reported problem. Please let me know whether the release works as expected for you.

!תודה רבה

from gspread-dataframe.

Laila92 avatar Laila92 commented on June 3, 2024

It works, thank you so much.

from gspread-dataframe.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.