Resolved: pandas Basic DataFrame concatenation not working in Python3

Question:

I’m doing a simple DataFrame concatenation tutorial for Python3. You can find this tutorial here: https://www.geeksforgeeks.org/dealing-with-rows-and-columns-in-pandas-dataframe/

import pandas as pd

# importing numpy as np
import numpy as np
 
# making data frame 
df = pd.read_csv('nba.csv', index_col ='Name') 
  
df.head(10)
  
new_row = pd.DataFrame({'Name':'Geeks', 'Team':'Boston', 'Number':3,
                        'Position':'PG', 'Age':33, 'Height':'6-2',
                        'Weight':189, 'College':'MIT', 'Salary':99999},
                                                            index =[0])
# simply concatenate both dataframes
df_new = pd.concat([new_row, df]).reset_index(drop = True)
df_new.head(5)
print(df_new)

Upon attempting to print df_new I get this output

0    Geeks          Boston     3.0       PG  33.0    6-2   189.0                MIT    99999.0
1      NaN  Boston Celtics     0.0       PG  25.0    6-2   180.0              Texas  7730337.0
2      NaN  Boston Celtics    99.0       SF  25.0    6-6   235.0          Marquette  6796117.0
3      NaN  Boston Celtics    30.0       SG  27.0    6-5   205.0  Boston University        NaN
4      NaN  Boston Celtics    28.0       SG  22.0    6-5   185.0      Georgia State  1148640.0
..     ...             ...     ...      ...   ...    ...     ...                ...        ...
454    NaN       Utah Jazz     8.0       PG  26.0    6-3   203.0             Butler  2433333.0
455    NaN       Utah Jazz    25.0       PG  24.0    6-1   179.0                NaN   900000.0
456    NaN       Utah Jazz    21.0        C  26.0    7-3   256.0                NaN  2900000.0
457    NaN       Utah Jazz    24.0        C  26.0    7-0   231.0             Kansas   947276.0
458    NaN             NaN     NaN      NaN   NaN    NaN     NaN                NaN        NaN

[459 rows x 9 columns]

This is not the expected output. I was wondering if I was doing something wrong as I re-downloaded the csv in case the csv was corrupted somehow however that does not seem to be the case. I am new to python so I’m trying to figure out why DataFrame.head() is not working in terms of not reducing the output dataframe to 5 elements, and why the actual values are being set to null.
If anyone has any ideas let me know.

Answer:

This is an error in the tutorial. Just read the CSV without “index_col=’Name'”, and run the same code and it will work

If you have better answer, please add a comment about this, thank you!

Resolved: pandas Basic DataFrame concatenation not working in Python3

Resolved: how to get and read an xml file in a zip file using xml.etree

Resolved: The ‘Access-Control-Allow-Origin’ header contains multiple values ‘, ’, but only one is allowed. cors error not resolving

Resolved: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘crm.email’ doesn’t exist (Connection: mysql, SQL: select count(*) as aggregate from `email`

Leave A Reply