astrofrog / astrofrog/psrecord

Issue with format when parsing activity.txt

Open
#41 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
680
Forks
79
PR merge metrics
No merged PRs in 30d

Description

Hi,

If I try to parse activity.txt file using Pandas, I get the output in a weird format.
Even though the columns are separate in activity.txt file, after parsing it through pandas all the columns are merged as one.

Is there a workaround to separate out the columns/clean the data so that it can be processed further ?

screen shot 2018-07-08 at 6 03 44 am

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the reported parsing of activity.txt with Pandas and compare the file's apparent column separators with the resulting single-column output. Identify the parsing behavior responsible and document or implement a reliable way to keep the columns separate; done means the activity data can be processed as distinct columns.

Written by the indexing model from the issue text.

Assessment

Tech stack
pandas, python
Domain
data
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.