Advertisements I am trying to execute this code: data[‘lga_code’] = data.loc[:,’lga’].apply(lambda x: ‘Rural’ if x == endswith(‘Rural’) (‘Urban’ if x == endswith(‘Urban’) else ‘other’)) But I get this error: SyntaxError: invalid syntax. What is wrong? The data is a dataframe that it has 125 categories. I want to group them all into three, and that’s… Read More What am I doing wrong with this syntax of multiple if – else in apply pandas?

Advertisements I have a df with multiple columns, one of which is a string with many words(text column). I also have a set of words, S, that I need to look for. I want to extract the rows of the df that contain at least one word from S in its text column df_filtered=df[df[‘text’].str.contains(‘word’)] This… Read More Search of a set of strings in a column containing strings in a pandas dataframe

Advertisements I have following DataFrame which start by an index of 1.10 and increment by 0.05: A B C D E 1.10 3 2 2 1 0 1.15 1 2 0 1 0 1.20 0 0 0 1 -1 1.25 1 1 3 -5 2 1.30 -3 4 2 6 0 … I want to… Read More Pandas extend DataFrame with Zeros

Advertisements I have a DF in which one of the columns has strings of the form 0 word1|category1 word2|category2 1 word3|category3 word4|category4 word2|category2 .. 2 word1|category1 word4|category4 word3|category3 .. where "word1|category1 word4|category4 word3|category3 .." is a string I need an output dictionary mapping that maps unique set of words to their respective categories. I tried… Read More pandas dataframe column string parsing

Advertisements For each row, I want that rows’ index to be changed to column_index, and have the whole thing split from x row * y columns to 1 row * x*y columns shape. import pandas as pd df = pd.DataFrame(data=[[‘Jon’, 21, 1.77,160],[‘Jane’,44,1.6,130]],columns=[‘name’,’age’, ‘height’,’weight’]) want = pd.DataFrame(data=[[‘Jon’, 21, 1.77,160,’Jane’,44,1.6,130]],columns=[‘name_0′,’age_0’, ‘height_0′,’weight_0′,’name_1′,’age_1’, ‘height_1′,’weight_1’]) # original df name age… Read More Reformat/pivot pandas dataframe

Advertisements I have been struggling to find a nice solution to this problem: I have a 100-rows-dataframe df1 , Col 0, Col 1, Col 2, Score, Combined … 23 Oslo, isCapitalOf, Norway, 0.9, None … I also have another 100-rows-dataframe df2 , Col 0, Col 1, Col 2, Score, Combined … 43 Norway, highestMountain, Galdhøpiggen,… Read More Python Dataframes: How can I apply a function to value x and y, where x is in df1 and y is in df2?

Advertisements If I have a DataFrame, df, for which df.index.empy is True, will this ALWAYS imply that df.empty is also True? My intend is to test only df.index.empy when I need to test both conditions (lazy programming style). >Solution : Yes, if one of the columns or index is empty, then the shape of your… Read More Does DataFrame.index.empty imply DataFrame.empty?

Advertisements I have a data Frame which contains different call types as below values CallType 0 IN 1 OUT 2 a_in 3 asms 4 INCOMING 5 OUTGOING 6 A2P_SMSIN 7 ain 8 aout I want to map this in such a way the output would be CallType 0 IN 1 OUT 2 IN 3 SMS… Read More Get Closest match for a column in data frame

Advertisements I have this dataframe: df0 = pd.DataFrame({‘points’: [0, 0, -3, 16, 0, 5, -3, 14], ‘assists’: [0, 0, 2, 0, 1, -7, 0, 6], ‘numbers’: [0, 0, 1, 6, 10, 5, 8, 7]}) and my desired dataset looks like this: points assists numbers colX 0 0 0 0 0 0 0 0 -3 2… Read More Get the name of columns from rows distinct from zero python

Advertisements A simple data frame that I want to add a column, to tell how many Teams that the Project has, according to a name dictionary. The way I came up with seems working ok but doesn’t look very smart. What is a better way to do so? Thank you. import pandas as pd from… Read More Pandas new column from counts of column contents