Python Forum
Best way to append data frame?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Best way to append data frame?
#1
I read by accident, somewhere online, recently that it is highly unsought to append/insert a data frame either row by row, or cell by cell (for iloc). I cannot recall which one exactly, but to the point; What is the best way to append data into a data frame? Here is the snippit I have. I am doing my best to work with PEP8 style guide while making changes at the same time so feel free to mention discrepancies in the style. I have a total of 12 columns and I feel that appending each line singly is not good to do. It looks too separated (for lack of better words to explain it).

                    # Sets the quantity #
                    InvoiceDataFrame.loc[[len(InvoiceDataFrame) - 1],
                                         InvoiceDataFrame.columns[3]]="1"

                    # Sets the class #
                    InvoiceDataFrame.loc[[len(InvoiceDataFrame) - 1],
                                         InvoiceDataFrame.columns[4]]=ClassIndex[LoadedSales.iloc[inx, 1]]

                    # Sets the Job name #
                    InvoiceDataFrame.loc[[len(InvoiceDataFrame) - 1],
                                         InvoiceDataFrame.columns[5]]=HA

                    # Sets the Terms #
                    InvoiceDataFrame.loc[[len(InvoiceDataFrame) - 1],
                                         InvoiceDataFrame.columns[6]]="Redacted"
Note: With regards to PEP8 Style Guide. I haven't taken time yet to change my variable names to match the style guide.
Reply


Messages In This Thread
Best way to append data frame? - by WuchaDoin - Oct-04-2018, 05:11 PM
RE: Best way to append data frame? - by volcano63 - Oct-04-2018, 07:17 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Grouping in pandas/multi-index data frame Aleqsie 3 2,247 Jan-06-2024, 03:55 PM
Last Post: deanhystad
  Filtering Data Frame, with another value NewBiee 9 3,027 Aug-21-2023, 10:53 AM
Last Post: NewBiee
  Exporting data frame to excel dyerlee91 0 2,102 Oct-05-2021, 11:34 AM
Last Post: dyerlee91
  Pandas Data frame column condition check based on length of the value aditi06 1 3,709 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Adding a new column to a Panda Data Frame rsherry8 2 2,936 Jun-06-2021, 06:49 PM
Last Post: jefsummers
  grouped data frame glitter 0 2,046 Feb-02-2021, 11:22 AM
Last Post: glitter
  how to filter data frame dynamically with the columns psahay 0 3,033 Aug-24-2020, 01:10 PM
Last Post: psahay
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 2,858 Aug-03-2020, 02:05 AM
Last Post: scidam
  How to shift data frame rows of specified column Mekala 0 2,492 Jul-21-2020, 02:42 PM
Last Post: Mekala
  HELP- DATA FRAME INTO TIME SERIES- BASIC bntayfur 0 2,162 Jul-11-2020, 09:04 PM
Last Post: bntayfur

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020