Comments (3)
Hey @robertsanna,
Glad you find your way to post your question!
To share your csv, go to https://gist.github.com/ and paste your csv there. Name it ela_score.csv
and click Create secret gist
. Then copy the url and paste it in your comment here.
The gist interface looks like the following (don't confuse the description
and filename
slots!)
Without seeing the dataset, it's hard for me visualize what values you are trying to aggregate/count in a pivot table (or if you should use a pivot table at all). Once I take a look at the dataset I'll be able to say more, since I know your intention :)
I want to take the ELA test scores from students from the Bronx, grade 6-8. I want to make sure that I can isolate the values of the scores, Levels 1-4, in the sheet labeled BouroughELAResults.
from call-me-maybe.
Hi, Jue! Thanks very much. Here's the URL. To my data set.
https://gist.github.com/robertsanna/809ac6ca5eb55dda949d
I am envisioning some type of chart where you can look at grade level, and corresponding scores by year. So the data has 2013, 2014, and 2015 scores for grades 6, 7, and 8. And then I would like to sort the data by the percentage of students that got 1's, 2's, 3's, 4's and 5's in each grade. Is that too many variables? I thought that maybe I could do a bubble chart using Plotly to do so. But I am not sure how to organize this information. Thanks for your help!
-Anna
from call-me-maybe.
Hey @robertsanna,
Apologies for the delayed reply! I looked into your data and experimented with plotly. If you are still looking for some guidance, here are a few things you might want to consider:
- You file is actually a TSV since it's delimited by tabs instead of commas. Rename it as
ela_score.tsv
to remain schematically correct. (This probably affect you right away, but in the future you might be wondering where you've introduced an error in your process. Clean data is always step one.) - To only show the scores for 13/14/15, and only for grades 6/7/8. Try googling selecting value based on cell value excel. Hint: usually go with the links by stackoverflow (a site where people post programming-related questions, from specific commands to abstract concepts, and creating a pivot table/writing an Excel Query is programming, believe it or not.)
- When you say "sort" by percentage -- do you mean to sort by the 1's, 2's, etc. respectively? If so you will be looking to sort 5 times... If you can tell me about your rationale of using the bubble chart, and also, your goal of this graph (like what is the name of the figure once you have it), it'll help me understand what it is that you need.
Let me know if this helps and if you have further or new questions.
(If you feel I'm creating more hoops for you to jump through, it's because navigating in the data space IS about getting over one barrier after another! And muscle memories come from your own practice :)
from call-me-maybe.
Related Issues (20)
- Doing a salary poll or survey - best tools? HOT 3
- help with app for coding class! HOT 3
- Summer project HOT 1
- Trouble with Final Assignment HOT 1
- Product Development Studio HOT 4
- Hi from WaPo's Data Journalism party!
- highcharts and google sheets HOT 1
- Making embedded Google chart responsive HOT 2
- .CSV Data Set won't completely open in Excel HOT 2
- Understanding My Data HOT 2
- Setting up my website HOT 1
- Help with google fusion and merging HOT 2
- MAP HELP HOT 4
- Map Help HOT 6
- Excel Help HOT 1
- Version control class, from John Campbell HOT 1
- Uploading StoryMap JS files to GitHub HOT 1
- Need your help... HOT 1
- Urgent Help, Infographic HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from call-me-maybe.