python - Dataframe PANDAS -

-

i want merge duplicate rows in particular column , rearranging data. instance, have following dataframe:

    cont    id1    id2    id3    id4    id5    id6    id7  63309    89     101.3  na     na     na     na     na     na  63309    89     na     102.3  na     na     na     na     na  63309    89     na     na     na     104    na     na     na  63309    90     na     na     103    105.0  na     na     na  63309    89     na     na     na     na     na     107.1  na  63310    92     na     105.1  105.3  789.1  104    na     na  63310    92     109    na     na     na     na     na     na  63311    94     104    109    890    na     na     na     107  63309    89     na     na     na     na     109    na     111

i want result in following format:

    cont    id1    id2    id3    id4    id5    id6    id7  63309    89     101.3  na     na     na     na     na     na           89     na     102.3  na     na     na     na     na           89     na     na     na     104    na     na     na           90     na     na     103    105.0  na     na     na           89     na     na     na     na     na     107.1  na           89     na     na     na     na     109    na     111   63310    92     na     105.1  105.3  789.1  104    na     na           92     109    na     na     na     na     na     na   63311    94     104    109    890    na     na     na     107

i know can use df.sort() arrange in ascending order. i'm looking particular formatting of 'from' column , adding empty space once there transition 1 unique 'from' row next unique 'from' row.

>>> df.set_index(['from', 'cont']).sort_index()                id1    id2    id3    id4  id5    id6  id7  cont                                              63309 89    101.3    nan    nan    nan  nan    nan  nan       89      nan  102.3    nan    nan  nan    nan  nan       89      nan    nan    nan  104.0  nan    nan  nan       89      nan    nan    nan    nan  nan  107.1  nan       89      nan    nan    nan    nan  109    nan  111       90      nan    nan  103.0  105.0  nan    nan  nan 63310 92      nan  105.1  105.3  789.1  104    nan  nan       92    109.0    nan    nan    nan  nan    nan  nan 63311 94    104.0  109.0  890.0    nan  nan    nan  107

you don't want spacer rows in dataframe. formatting issue.


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more